SQL Server Performance Forum – Threads Archive
Max amount of db’s in SQL Svr?
Hi, <br /><br />This may seem like a bit of a strange question but is there any limit to the amount of databases that SQL Server 2000 can handle? Also, does anybody know the maximum db size it can handle?<br /><br />Thanks!!<br /><br />[<img src=’/community/emoticons/emotion-5.gif’ alt=’
‘ />]
Databases per instance is 32,767 and it depends how many instances a machine can handle.
And the size of db is limited to 1,048,516 TB. Refer to books online for Maximum Capacity Specifications to know each and every option you want. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
The limit of 32,767 databases per instance is a theoritical limit and comes from the ‘dbid’ column of the ‘sysdatabases’ table. The data type of this column is smallint which can accept numbers up to 32,767. Since every database created in an instance should have a dbid and hence the limit of 32,767. But, as you might have already experienced, you should never go to the extremities of SQL servers <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />
The capacity specifications does reflects the same as per the column datatype in the sysdatabases, I have never seen any example or information that somebody have 32,767 database in a SQL instance. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
also checkout the following Microsoft Knowledge Base Article – 316749
PRB: There May Not Be Enough Virtual Memory with Large Number of Databases apparently each updated db uses 2-3 64KB blocks for administrative purposes
while this is not much, it does consume address space which must reside in the lower 2-3GB range
]]>