Post reply

Max DB's per instance

  • July 23, 2008 at 8:31 am

    #188346

    Whats the max Number of databases that can be installed on a single instance of SQL Server 2005?

    also i have two boxes in prod one server1 running SQL 2005 A/P Cluster (60 DBs) and the other server2 2000 (40 DBs), there is now a new requirement is to integrate daabases from 2000 to 2005 box.

    1. would it be best to install second instance of 2005 on server1 and migrate the 40 databases (39 GB totall size) on server2 to server1 (currently 90 GB total size)

    or

    2. Should i just migrate those databases to the current SQl instance on server 1.

    what are the caveats of of these approach.

    thanks

  • July 23, 2008 at 8:50 am

    #847099

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

    16 instances for workgroup edition.

    50 instances for all others.

    25 instances if using a failover cluster.

    If the databases do not conflict, moving them to a single instance will reduce the overhead - a second instance adds some overhead.

    However, the overhead is not much when you are talking about 100 databases. Having two instances would allow you to control the resources used by each instance, so you could set one instance to only use 1/2 of the processors or less memory - this may be useful.

  • July 23, 2008 at 8:55 am

    #847105

    Max Databases per instance of SQL Server = 32,767

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 23, 2008 at 8:59 am

    #847108

    Oh - yes, there I go not paying attention.

    Yes, 32,767 databases per instance.

    If you run into that being a problem, you probably have a design issue.

  • July 23, 2008 at 9:23 am

    #847141

    ok thx,

    I'm thinking abt installing a second SQL instance on the cluster and migrating those databases to this new instance .

    I want to setup this instance in a way that will not require seperate LUN for storage from SAN. In order to accomplish this,

    1. will i have to install the second instance on the active node, and share disk storage for new database file.

    or

    2. Can i achieve the same by installing new instance on the passive (converting cluster to Active/Active)

    Thanks for your thoughts on this

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply