Click here to monitor SSC
SQLServerCentral is supported by Redgate
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

Throwback Thursday #1: SQL Inspire

What Is Throwback Thursday?

One of my hobbies is being a turntablist. In high school I took a job just so I could buy myself two Technics 1200’s, crates full of records and a mixer. I love scratching, beat juggling, and mixing accapella tracks over instrumentals. The radio… Read more

0 comments, 468 reads

Posted in John Sterrett on 14 November 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, 620 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, 1,062 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

6 comments, 3,682 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, 1,341 reads

Posted in John Sterrett on 8 October 2013

Learn SQL Server Performance Tuning Basics in a Single Day

Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction to SQL Server Performance Tuning training opportunity for you in Pittsburgh on September 13th. It will be given as a PreCon for SQL Saturday #250 in Pittsburgh. Konstantin… Read more

0 comments, 2,457 reads

Posted in John Sterrett on 28 August 2013

Workload Tuning: Finding Top Offenders in SQL Server 2012

I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance tuning usually starts with finding your top offenders so you can get the biggest bang for your tuning bucks. For the first time, you can capture a workload using… Read more

1 comments, 2,079 reads

Posted in John Sterrett on 7 August 2013

First Look: Microsoft SQL Server 2014

Last week at TechEd 2013 in New Orleans Microsoft publicly released details about the SQL Server 2014 CTP 1. Here are some good reads about the information shared by Microsoft and the blogsphere.

Microsoft Info

Signup for 2014 CTP 1 bits ->

Hekaton White Paper for CTP1 -> Read more

0 comments, 1,450 reads

Posted in John Sterrett on 11 June 2013

I am Speaking at 2013 PASS Member Summit!

Speaking at PASS Summit 2013

Every single year I look forward to the PASS Member Summit. In a nutshell it is the SuperBowl for SQL Server Professionals. It is so vital to my career I have paid my own way.  It is the best place to connect, share… Read more

2 comments, 766 reads

Posted in John Sterrett on 30 May 2013

T-SQLTuesday #42: The New Adventure!

It’s time for T-SQL Tuesday the forty-second, Wendy Pastrick asked that we talk

T-SQL Tuesday!

about our experiences with change in our work lives. I’d like to share some exciting news about myself and the new adventure I am taking.  Earlier this month I started a new journey with… Read more

0 comments, 444 reads

Posted in John Sterrett on 14 May 2013

Benchmark SQL Server Disk Latency

Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking disk counters for SQL Server.  Typically, you will see people applying best practices like having dedicated spindles for transactional log files and dedicated spindles for data files.  With… Read more

8 comments, 3,362 reads

Posted in John Sterrett on 25 February 2013

SQL Server Performance Tuning with Free Tools!

The following is a recording of my Performance Tuning for Pirates session recorded by UserGroup.TV at SQL Saturday 125 in Oklahoma City.  I recommend that you check out UserGroup.TV as they provide some great content for free.  It was an honor to be selected for this recording.  I hope… Read more

4 comments, 721 reads

Posted in John Sterrett on 14 January 2013

12 Steps to Workload Tuning – Winter 2012 Performance Palooza!


[UPDATE] Video recording from PASS Virtual Performance Chapter’s Winter 2012 Performance Palooza can be found here.

I am a huge fan of the PASS Virtual Performance Chapter and I am excited that they pinged me to speak at their Winter 2012 Performance Palooza event tomorrow. This event is… Read more

0 comments, 617 reads

Posted in John Sterrett on 5 December 2012

#sqlpass #summit12 day two keynote review

The following is my highlights and thoughts about the day two keynote at the SQL PASS Member Summit.

Douglas McDowell started recapping yesterday events shortly followed by some great information about PASS financials. Five years ago there were no SQL Saturday, no 24hrs of PASS less than half the amount… Read more

0 comments, 535 reads

Posted in John Sterrett on 8 November 2012

5 recommendations for attending #sqlpass #summit12

The following are five recommendations I would like to share with anyone attending the #sqlpass member summit. I hope you have a blast!


If you have a smart phone I highly recommend grabbing the GuideBook application for your mobile device. This will give you direct access to the session… Read more

0 comments, 389 reads

Posted in John Sterrett on 7 November 2012

Is #SQLPASS helping their speakers?

I love the SQL Community because it usually is a great environment to connect, share and learn. With that said, I am noticing that we can do a much better job with helping the people who share, learn how to share better.  For every single, Grant Fritchey, Thomas LaRock Read more

7 comments, 1,085 reads

Posted in John Sterrett on 30 October 2012

Dallas, TX to Pittsburgh, PA A #sqlsat171 Story!


First SQL Saturday in Pittsburgh

It was an honor to speak at the first SQL Saturday in Pittsburgh. The company I

We even got some professional development done while I was in the office.

currently work for is based out of Pittsburgh so I flew in a week early… Read more

1 comments, 346 reads

Posted in John Sterrett on 12 October 2012

Presenting at OKC SQL Server User Group Tonight!

Tonight, October 8th at 6:30pm I am virtually speaking at the OKC SQL Server User Group.  I had a blast there earlier this year when I presented at their SQL Saturday event.  Tonight I will be talking about Performance Tuning for Pirates! There will be free knowledge and food… Read more

2 comments, 358 reads

Posted in John Sterrett on 8 October 2012

Upcoming speaking engagements

Ayyyy, matey being that today is the International Speak Like a Pirate Day I thought it was appropriate to post some future dates for my Performance Tuning for Pirates presentation.

You can download the slides, check out the reference material and videos here!

North Texas SQL Server Group

If your… Read more

0 comments, 264 reads

Posted in John Sterrett on 19 September 2012

#TSQL2Day – A Day in the Life of A Service DBA

Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin Stellato is the king pin and her topic is “A day in the Life.” This gives me a great opportunity to explain a day in the life of a… Read more

2 comments, 324 reads

Posted in John Sterrett on 18 July 2012

Newer posts

Older posts