Thursday, November 12, 2009

Allocation of Database Size for SharePoint Applications

I wanted to share my new finding related to allocating correct available space for SharePoint database.

I was unable to see a better load time of pages when the available database size was less than 30% of the current level.

It was only after I made it 30% auto growth for all the db size in Share Point server I was able to see normal loading of the pages. To make it simpler I give an example here. If your current database size is say 10, 000MB then the availble space should be 10,000MB + 10,000 * 30% of 10,000 which truns out to be 13000MB. Aftre this if you set the autogrwoth property of the database size as 30% then you will experince that the pages are loading faster than before.

Though it was trial and error method through which I learned and took much time to do the same that is the reason I want to share this as it might save a good amount of time for you or just simply avoid this scenarios. The performance impact was immediate and pages where also rendering faster than before.