Details

Performance Tuning for Mere Mortals Part II

Speaker(s)Mike Lawell 

Duration: 60 minutes

Track: DBA

This is part two of a two part series, looking at performance tuning (i.e. performance troubleshooting) from the beginning. Part II is about the next steps after taking a look at some of the free performance analysis tools. This session will go into more detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events. 

This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning. 

There will be homework!


Back to Top