SQL Server Performance Forum – Threads Archive
maximum no of databases on sql servrWhat 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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
32,767 check all the other limitations
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. —
SQL Server MVP
True and for fun you can calculate the numbers. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.