Re: Numbers of DB in SQL

From: David (David_at_discussions.microsoft.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 14:31:02 -0800

Thanks for replied my post. My server is a Dell 8450 Quad-processors with 2
GB of RAM.

"David Portas" wrote:

> The documented limit is 32767 databases per server instance, so you have
> some way to go yet! With the appropriate hardware 45 databases is certainly
> no problem.
>
> --
> David Portas
> SQL Server MVP
> --
>
>
>

Relevant Pages

  • Re: mdf and log files on network attached storage?
    ... "David Portas" wrote: ... > Server is a separate backup process altogether and backup is configured ... not per server. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: will sql 2000 install on server 2003 web edition
    ... will support server 2003 web version ... "David Portas" wrote: ... > Only SQL Server MSDE is supported on web edition. ...
    (microsoft.public.sqlserver.setup)
  • RE: IS NULL not working in WHERE clause.
    ... Please see my return post to David Portas. ... The same query running against a table ... >> seems to be breaking SQL Server(?) ...
    (microsoft.public.sqlserver.programming)
  • Re: Combine the rows data into one single column
    ... The job of the server is to return a tabular result set, ... Presentation belongs client-side. ... David Portas ...
    (microsoft.public.sqlserver.programming)
  • Re: Alocated Memory Error (SQLSERVR)
    ... but my understanding is that the MSDE instances are designed to ... and you don't want it grabbing all that RAM. ... running but non ever going about 200mb of memory usage. ... Server 2000 SP4, ...
    (microsoft.public.windows.server.sbs)