SQLWebpedia

Best Practices Information for SQL Server Performance

 External Articles on Server Performance

• Top SQL Server 2005 Performance Issues for SQL 2005 for OLTP
• Performance Profile of OLTP Applications
• Finding duplicate and overlapping indexes - Duplicate indexes will slow down insert performance in OLTP environments. DBAs disagree on the fact that it still can be a good idea to have overlapping indexes, so test your stored procedures to see what indexes they use first.
• SQL Server Performance Counter tips
• Troubleshooting SQL Server 2005 Performance Whitepaper

Dedicated Sites

• http://blogs.msdn.com/sqlcat/ - SQL Server Customer Advisory Team. They are focused on performance issues for enterprise environments.
• Technet Best Practices for SQL Server
• http://www.sql-server-performance.com - Name says it all. Bought by commercial interests, but they are still holding true to its name.
• Louis Davidson is writing an ebook for DMV's which are key for troubleshooting performance.

External Sites Dedicated to Programming Optimization

• SQL Programmibility Team Blog 

Tools to Investigate Server Performance

• PSSDiag - SQL 7/2000
• SQL Server 2005 Health and History Tool
• SQL Server 2005 Performance Collector Tool - Works with Health and History Tool.

Patches to Fix Performance Related issues

• Patch - 32 bit servers with > 2GB of RAM using AWE switch running SQL 2000 SP4.