Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

John Sterrett

John Sterrett is very active within the SQL Server community. He is a PASS Regional Mentor for the South Central Region, co-founded the West Virginia SQL Server User Group and hosted two PASS SQL Saturday events in West Virginia. John has presented at several SQL Server events including PASS SQLRally, PASS Member Summit, many PASS SQL Saturday events, code camps, and, user groups. John is a syndicated blogger at http://johnsterrett.com.

Archives: October 2013

SQL Server Performance Root Cause Analysis in 10 Minutes

This year I was honored to be selected by Dell Software to present a ten minute session in their booth (#200) at the 2013 SQL PASS Member Summit. I decided to share how I do a SQL Server Performance Root Cause Analysis in 10 minutes with the SQL Community. Read more

6 comments, 267 reads

Posted in John Sterrett on 15 October 2013

Finding Top Offenders From Cache

When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find the queries causing the top waits. Next, I like to understand what is running and monitor disk latency. Finally, I would like to probe the cache to see… Read more

0 comments, 705 reads

Posted in John Sterrett on 14 October 2013

What Queries are Causing My Waits?

In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once I have found my top wait types is to use extended events to figure out the SQL statements causing the majority of the waits for those wait types.… Read more

5 comments, 3,097 reads

Posted in John Sterrett on 10 October 2013

Benchmark SQL Server Wait Statistics

One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid) changes its status from running to suspended it is typically due to resource wait or a signal wait. For example, you are typically waiting on PAGEIOLATCH_SH when you run a… Read more

10 comments, 612 reads

Posted in John Sterrett on 8 October 2013