SQL Server 2005 - Show Me Your Secrets
Posted: 2/17/2009 1:31:06 PM
By: Comfortably Anonymous
Times Read: 2,004
0 Dislikes: 0
Topic: News: Technical

 The SQL script from the article below makes it simple to get massive performance increases in SQL Server 2005. I’ve used it religiously since they released it in the Jan 2008 issue of MSDN Magazine.

You just run it against the Master DB (It just does a bunch of reads of counters within Master DB, no writes.) and it comes up with a checklist of stuff to tune. The best is the “Missing Indexes” part - Add those missing indexes and usually you see some excellent SELECT performance increases. (Also get rid of any unneeded indexes it finds, they just slow down INSERT performance.)

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

Rating: (You must be logged in to vote)