Ben Curry - CISSP, SharePoint Server MVP

All MindsharpBlogs

http://www.microsoft.com/mspress/books/10623.aspx

My Links

Archives

Image Galleries

Blog Stats

Favorite SharePoint Books

My Favorite Blogs

Change the default SQL Server settings for performance

Did you know the default autogrow (filegrowth) settings for SQL Server is 1MB at a shot? That can really hurt your SharePoint Server performance. The best practice is to set the inital size to your max size, like 100GB. But, if you must use autogrow, here is a sample script you can run in SQL Server Management Studio. Note that it also sets the initial size. I would make that initial size something like 50GB.

Use Master;
Go
alter database Contoso_WSS_Content_Portal_01
modify file
(NAME = Contoso_WSS_Content_Portal_01,
SIZE = 1024MB,
MAXSIZE = 51200MB,
FILEGROWTH = 1024MB);
go

That will change the data file 'Contoso_WSS_Content_Portal_01' to 1GB initial size, with 1GB autogrow increments.

Thanks to Brian Alderman for the help tuning the above. Also, check out Mike Watson's blog here. He and Bill Baer really know their SQL!

Ben

posted on Tuesday, May 20, 2008 12:04 PM

Feedback

# SharePoint Performance Quick Wins / Tips 5/21/2008 12:17 AM Ben Curry - CISSP, SharePoint Server MVP

# SharePoint Performance Quick Wins / Tips 5/21/2008 12:19 AM Ben Curry - CISSP, SharePoint Server MVP

# WSS 3.0 & MOSS: Recopilatorio de enlaces interesantes (XVIII)! 6/19/2008 5:06 PM Blog del CIIN

Tal y como os adelantaba en el último post , aquí tenéis la enésima entrega...bueno más bien la 18ª sobre


Comments on this post are closed.
Title  
Name  
Url
CAPTCHA
Protected by Clearscreen.SharpHIPEnter the code you see:
Comments