Mission Possible: Interactive Performance Troubleshooting - Index

Abstract:

Performance troubleshooting is detective work. We'll have a lab system being assaulted by PowerShell scripts (to simulate live users), and simulated performance problems like those that can make your on-call cell phone ring too much! Do you think you have what it takes to find these "needle in the haystack" issues and resolve them quickly? This will be a highly interactive session where we will locate the rogue queries together, work through solutions, implement them and measure the results. In this episode we'll focus primarily on improper indexing as a common underlying problem and all will walk away with much better troubleshooting skills and an upgraded knowledge of performance tuning!

Speakers:

  • Jim Murphy

    2 Recordings

    Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90's. He is the CEO of SQLWatchmen, LLC., a remote DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central and is a regular speaker at SQL conferences nationwide. He has been a professional DBA and developer for over 20 years and has been founder and CEO since 2001.

Recorded At:

Recorded on:

Aug 13, 2016

More Info:

http://www.sqlsaturday.com/550/Sessions/Details.aspx?sid=50342

Tags: