Looks not very good to have more than 100 site collections (which have their own db) in a single web app.
http://technet.microsoft.com/en-us/library/cc262787.aspx<https://webmail.telecom.co.nz/owa/redir.aspx?C=e0c76c9fff1b4c7e9f3568be7dbde594&URL=http%3a%2f%2ftechnet.microsoft.com%2fen-us%2flibrary%2fcc262787.aspx> >From the above article... Guidelines for acceptable performance Content database 100 per Web application Similar guidance is for Query servers Query servers No limit Because 100 content databases are supported for each query server, the number of query servers required per farm is based on the number of content databases in the farm. For example, if there are 500 content databases in your farm, you will need at least 5 query servers. On Thu, Mar 25, 2010 at 4:30 PM, Paul Noone < paul.no...@ceosyd.catholic.edu.au> wrote: > 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 it comes to scalability, there ideally are two ways to achieve it > > 1. Scaling up or > > 2. Scaling out. > > > > Scaling up is normally done to manage volume on a single high performance > server, while scaling out is ideally used to distribute load among multiple > servers, also, with scaling up you add resources to your server, with > scaling out, you add servers to your cluster. > > > > Cheers > > Rahul > > > > -------- Original Message -------- > Subject: RE: No. of sharepoint databases in Sql Server > From: Paul Noone <paul.no...@ceosyd.catholic.edu.au> > Date: Wed, March 24, 2010 8:19 pm > To: ozMOSS <ozmoss@ozmoss.com> > > > And if you enable usage statistics you can expect that space to dwindle > very, very quickly indeed. > > > > Regards, > > Paul > > Online Developer, ICT > CEO Sydney > > > > *From:* ozmoss-boun...@ozmoss.com > [*mailto:ozmoss-boun...@ozmoss.com*<ozmoss-boun...@ozmoss.com>] > *On Behalf Of *Daniel Brown > *Sent:* Thursday, 25 March 2010 1:52 PM > *To:* ozMOSS > *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, Ajay > <*akhanna...@gmail.com*<akhanna...@gmail.com>> > wrote: > > 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 > *ozm...@ozmoss.com* <ozmoss@ozmoss.com> > *http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss*<http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss> > > > ------------------------------ > > _______________________________________________ > ozmoss mailing list > ozmoss@ozmoss.com > *http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss*<http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss> > > > _______________________________________________ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > >
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
