SQL Server 2005 - Show Me Your Secrets
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.)
This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe this constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit to those who have expressed a prior interest in receiving the included information for research and educational purposes. For more information go to: http://www.law.cornell.edu/uscode/17/107.shtml
. If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner.