Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...

Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.  Read more...

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.  Read more...