Identifying Blocking Chain in SQL Server

HAPPY NEW YEAR 2017!! I hope you all had a good Christmas and New Year. I always try to review my skills as a DBA and explore different option to make my job easier. Recently, I was working on the blocking issue of SQL Server and found that there were a lot of sessions which were being blocked. Sometimes, […]

Read more
Capturing Current Workload of SQL Server – Part2

In the first part of the capturing current workload of SQL Server blog, I talked about first two steps. Where we created the table “CurrentlyRunningQueries_Snapshot_History” in the first step and wrote the script to capture workload for a live system in the second step. Now, we are going to create and schedule a job which […]

Read more
Capturing Current Workload of SQL Server – Part1

We often get a complaint from our client or application team that this particular query sometimes performs worst or at this specific time, the whole system performs very poorly. And, they want you to find the cause of performance issue. To start with basic performance troubleshooting, you need historical data which can tell you what […]

Read more