Mission Possible: Interactive Performance Troubleshooting - Index

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!

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

• SQL Saturday 127 Recordings

• SQL Performance 20 Recordings