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
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
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
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.
Signup for 2014 CTP 1 bits -> http://technet.microsoft.com/en-us/evalcenter/dn205292?WT.mc_id=Blog_SSQL_TechEdNA_SQL2014
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
It’s time for T-SQL Tuesday the forty-second, Wendy Pastrick asked that we talk
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
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
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
The following are five recommendations I would like to share with anyone attending the #sqlpass member summit. I hope you have a blast!
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
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
You can download the slides, check out the reference material and videos here!
North Texas SQL Server Group
If your… Read more
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
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help you with your performance tuning process. Today, I am happy to share my first video going over these tools.
Using SQLQueryStress to stress test Stored Procedures
If you work with SQL Server and live in the Harrisburg area I have some great news for you. The newest SQLPASS User Group has been born in your neck of the woods. The Central PA SQL Server User Group (CPSSUG) will be having their first official meeting tomorrow on… Read more
This week I have two presentations on my schedule. I get to give my Performance Tuning for Pirates presentation twice this week.
Pittsburgh SQL User Group Recap
Recently, I caught my during a kickoff with a new client saying, “Hello I am John, and I love SQL. If SQL Server asked for more heart I will not say no!” That’s right folks I am a very lucky guy. Everyday I get to wake up stroll on down… Read more