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 options 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, […]
Capturing Current Workload of SQL Server – Part2
Read more
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 […]
Capturing Current Workload of SQL Server – Part1
Read more
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 […]