Performance Tuning for Pirates

Speaker:

John Sterrett

Abstract:

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. 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.

Bio:

John Sterrett is a senior database administrator at Remote DBA Experts. John has been active within the SQL Server community, including hosting the first and second SQL Saturday in West Virginia. John also presented a spotlight session at SQL Rally and a lightning talk and chalk-talk at the SQL Server 2010 Member Summit, presented sessions at SQL Saturday’s, and presented to the Pittsburgh SQL Server User Group. John is one of the co-founders for the WVPASS User Group.

Recorded At:

SQL Saturday #125 Oklahoma City 2012

No Responses to “Performance Tuning for Pirates”