SQL Server Performance Forum – Threads Archive

maximum no of databases on sql servr

What is the maximum no of databases which can be created on a db server.What will happen if this exceed.?

Is a big number. But that big number (don’t remember right now) is about objects. That include: databases, tables, triggers, sp, etc.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

32,767 check all the other limitations
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

So, maximum possible databases (theoretically) in a server are 524,272.
(16 instances * 32,767 databases)
[8D] /* SKChandra */

This is a mere theoretical number. In practise you won’t get anywhere near this number. Some systems are more than busy with one single db.
And if you get to exceed this number, I suspect you’ll receive an error just stating that. —
Frank Kalis
SQL Server MVP
http://www.insidesql.de

True and for fun you can calculate the numbers. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>