If you follow baseball, you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. SQL Server Performance Tuning for Pirates is for anyone who wants to squeeze as much performance as possible without shrinking your wallet. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.
This session assumes some knowledge of code tuning and performance tuning and general knowledge about performance counters and SQL Server traces.
Session takeaways:
• Improve or establish a performance tuning process
• Learn how to use several free tools to help you with your performance tuning process
• Learn how to mitigate common performance problems
#24HOP slide deck is now available. You can also download t-sql queries here.
Tools
- DMV’s
- WhatIsRunning?
- Glenn Berry’s DMV Queries (Includes several proc cache queries)
- SQLQueryStress (Adam Machanic)
- Performance Analysis of Logs (PAL) Tool
- PSSDiag and SQLDiag Manager
- Clear Trace
- SQL Nexus
- SQL Diag (included when SQL 2005/2008 is installed)
- RML Utilities
White Paper’s & Links
- Troubleshooting Performance Problems in SQL Server 2008
- Performance Tuning Waits and Queues
- Performance Tuning with RML (SQLCAT)
- Performance Troubleshooting using the PAL tool (Mike Lagase)
- Quest -Free DMV Poster
- Quest – Free Perfmon Poster
- Monitor disk usage per database file (Randy Dyess)
- Correlating SQL Server Profiler with Performance Monitor (Brad McGee)
- SQL Wait Stats or Tell Me Where It Hurts (Paul Randal)
Books
- Mastering SQL Server Profiler
- Troubleshooting SQL Server: A Guide for the Accidental DBA
- SQL Server 2008 Query Performance Tuning Distilled
- Professional SQL Server 2008 Internals and Troubleshooting
Video
Pingback: Stress Testing Stored Procedures with Free Tools | JohnSterrett.com