Category Archives: SQL

The accidental SharePoint DBA series: Max Memory

Although most of this article is still correct, things are slightly different in SQL Server 2012. See​ Memory Manager Configuration changes in SQL Server 2012​​

It’s been a while since I’ve written an article that highlights a common misconception. This isn’t least because the last time I did this I received comments from one or two apparently disgruntled readers. No one likes to be told that they are wrong and in fairness, that particular article made a couple of sweeping statements. This was somewhat deliberate to spark a discussion and the article triggered a fair number of comments and follow up emails. Continue reading

SharePoint, SQL server fill factor and index rebuilds – a correction


Today we are going to be taking a look at the fill-factor option that is available within SQL Server 2005 and later, in the context of Microsoft SharePoint.

Aside from providing reasons for caring about fill-factor, I point out a mistake in the SQL maintenance guidance for both SharePoint 2007 and 2010 that relates to index rebuilds that I have made Microsoft aware of. Continue reading

SharePoint 2010 SQL DB autogrowth – leave it on!

I was on the MSDN forums recently discussing SharePoint database index fragmentation and spotted a question around SharePoint database autogrowth that I thought was interesting. Although this has been raised several time in the past (Alex Dean blogged about it back in 2009) , I thought it worth clarifying this once more now that SharePoint 2010 is RTM. Continue reading