# of SQL 2000 Databases

Is there a limit to the number of SQL databases you can
have on one server? If I remember correctly it depends
only on space and memory. We currently have 49 databases
running on one server and we are continueing to grow. The
server is running fine as far as memory goes and we have
plenty of space but I wanted to make sure we don't have a
limit as far as the amount of databases we are aloud on
one server.Books Online, Maximum Capacity Specifications, say that the max number is
32,767 per instance. So you are quite far from limit...
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Shannon" <anonymous@.discussions.microsoft.com> wrote in message
news:06e701c3aeaf$a6ec9c20$a001280a@.phx.gbl...
> Is there a limit to the number of SQL databases you can
> have on one server? If I remember correctly it depends
> only on space and memory. We currently have 49 databases
> running on one server and we are continueing to grow. The
> server is running fine as far as memory goes and we have
> plenty of space but I wanted to make sure we don't have a
> limit as far as the amount of databases we are aloud on
> one server.|||See the topic "Maximum Capacity Specifications" in SQL
Server Books ONline. The documented limit noted there is
32767.
In theory you're only limited to memory, I/O, processor,
etc., but also think about manageability: do you actually
WANT to manage 1000 databases under one instance?
If you're interested in things like this, which is more of
a consolidation scenario, I suggest you look at the
Planning for SQL 2K Consolidation whitepaper since it
talks about the combined gotchas.
>--Original Message--
>Is there a limit to the number of SQL databases you can
>have on one server? If I remember correctly it depends
>only on space and memory. We currently have 49 databases
>running on one server and we are continueing to grow. The
>server is running fine as far as memory goes and we have
>plenty of space but I wanted to make sure we don't have a
>limit as far as the amount of databases we are aloud on
>one server.
>.
>|||Note that the GUI tools might not be that well suited when you go above somewhere between 100 and
200 databases. Also, having an steadily increasing number of database might be an indication of
questionable design.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Shannon" <anonymous@.discussions.microsoft.com> wrote in message
news:06e701c3aeaf$a6ec9c20$a001280a@.phx.gbl...
> Is there a limit to the number of SQL databases you can
> have on one server? If I remember correctly it depends
> only on space and memory. We currently have 49 databases
> running on one server and we are continueing to grow. The
> server is running fine as far as memory goes and we have
> plenty of space but I wanted to make sure we don't have a
> limit as far as the amount of databases we are aloud on
> one server.|||Hi,
Dont worry, You can have 32767 databases per instance.
Thanks
Hari
MCDBA
"Shannon" <anonymous@.discussions.microsoft.com> wrote in message
news:06e701c3aeaf$a6ec9c20$a001280a@.phx.gbl...
> Is there a limit to the number of SQL databases you can
> have on one server? If I remember correctly it depends
> only on space and memory. We currently have 49 databases
> running on one server and we are continueing to grow. The
> server is running fine as far as memory goes and we have
> plenty of space but I wanted to make sure we don't have a
> limit as far as the amount of databases we are aloud on
> one server.