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.
Unsure on total number, but I would assume it depends greatly on resources,
disk/CPU/ram due to the nature of the beast. The more resources, the faster
disks, etc would dictate it to a large degree i believe.
-DB
On Thu, Mar 25, 2010 at 10:19 AM, Ajay wrote:
> I am looking at project where we
Subject: Re: No. of sharepoint databases in Sql Server
Unsure on total number, but I would assume it depends greatly on resources,
disk/CPU/ram due to the nature of the beast. The more resources, the faster
disks, etc would dictate it to a large degree i believe.
-DB
On Thu, Mar 25, 2010 at 10:19 AM
resources to your
server, with scaling out, you add servers to your cluster.CheersRahul
Original Message
Subject: RE: No. of sharepoint databases in Sql Server
From: Paul Noone
Date: Wed, March 24, 2010 8:19 pm
To: ozMOSS
And if you enable usage statistics you can
Whereas scaling around is just skirting the problem and won’t get you anywhere.
;)
From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of
ra...@nationalcom.com
Sent: Thursday, 25 March 2010 2:29 PM
To: ozMOSS
Subject: RE: No. of sharepoint databases in Sql Server
When
scaling around is just skirting the problem and won’t get you
> anywhere. ;)
>
>
>
> *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On
> Behalf Of *ra...@nationalcom.com
> *Sent:* Thursday, 25 March 2010 2:29 PM
> *To:* ozMOSS
>
> *Subject:* RE: No