See: http://stackoverflow.com/questions/1054016/maximum-number-of-databases-in-sql-server-2008
What matters is how much memory, CPU and disk you have for the load, not how many DBs. I have seen production systems with 100s of DBs that seem to work fine. ________________________________________ From: ozmoss-boun...@ozmoss.com [ozmoss-boun...@ozmoss.com] On Behalf Of Ajay [akhanna...@gmail.com] Sent: Thursday, 25 March 2010 10:49 AM To: ozMOSS Subject: No. of sharepoint databases in Sql Server I am looking at project where we will be provisioning new site collections in a new DB. Is there any kind of recommendation that how many databases we can have in Sql Server. I think I read somewhere that having more than 60 dbs can degrade performance,, can't find where I read. Please let me know your thought, recommendations on this Cheers, A _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
