Geek Sync Webcast : CSI for SQL: Learn to be a SQL Sleuth

Presenter: Mindy Curnutt
Share This:  Facebook Twitter LinkedIn

This session shows you how to use the "bottom up/top down" methodology to quickly determine whether the source of a performance problem is your hardware, your database or both.

Developed over a period of 30 years (initially for the mainframe), this methodology applies well to most database systems. Starting with the bottom-up analysis, we will look at the four typical areas where hardware performance issues happen: disk, memory, network, or processor. Using the PAL tool from Codeplex, we will review which Perfmon counters to look at (for SQL Server), how to collect and store the data, and ways to review and report on it. Next, we will match the Perfmon findings up with a top-down approach, looking for long-running, repetitive or excessive queries using XEvents. Approaching the problem from both sides leaves hardly a stone unturned. The server CAN tell us what the problem is, we just need to ask the right questions.

Register for Free Webcast
*
*
*
*
*