If you follow baseball you will notice that my favorite team the Pittsburgh Pirates has to do more with less to be successful. Working as a consultant, I have also noticed this trend with several IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. I will help improve your performance tuning process while using several free tools. Through this presentation we will go over wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.
#24HOP slide deck is now available. You can also download t-sql queries here.
Performance Tuning for Pirates!
View more presentations from John Sterrett
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