Whenever a disaster occurs it will be a stressful scenario regardless of how small or big the disaster is. This gets multiplied when it is your first time working with a newer technology or the first time you are going through a disaster without a proper run book. Today, were… Read more
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00 PM (EDT)
Do you need to build a High Availability (HA) and/or Disaster Recovery (DR) strategy for SQL Server Databases? If so, you will no doubt have questions like: Read more
In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the covers it can be harder to figure out the following two questions. When did the availability group failover? Where did the availability group go when the failover occurred? The goal… Read more
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month.
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where I dig deep into my evernote collection and find some great content on a single subject and share it with you. In the third installment of the Throwback Thursday… Read more
I hope everyone is having a great Thanksgiving with their families. When you come out of that food coma I hope you enjoy my second blog post in the Throwback Thursday series. Throwback Thursday is a bi-weekly blog series where I dig deep into my evernote collection and find some… Read more
I have a quick secret to share with my readers. Ever since I saw Tom Larock’s SQL Server Blogger rankings I have always wanted to be on that list. Today, that happened. To many it might seem like a small accomplishment towards bigger accomplishments. Right… Read more
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
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
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
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
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