Number of Databases per Instance

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Number of Databases per Instance

Author

Topic

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2010-10-15 : 09:10:02

Hello,

Is there a limit or "best practice" as to the number of databases you can have under a single instance of SQL? Or does it simply depend on server horse power (CPU, Memory, Disk I/O)?

I'm using SQL 2008 R2

Thank you,
Terry

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2010-10-15 : 09:15:59

Never mind. I found the answer.

Technically you can have 32,767 ... But it really depends on horse power.

Regards,
Terry

Thanks,
Terry

balakrishnachow
Starting Member

24 Posts

Posted - 2010-10-18 : 05:49:21

Hi guy,

default databases are created by sqlserver(Model,Master,Tempdb,Msdb,Distributer,system resourcedb)then we are able to create 32,760..only

Thanks
BalaKrishna.B

good

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources