This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
SQL SERVER – Simple Example of READPAST Query Hint
The required was very unique and we were able to solve the problem with the help of READPAST query hint. Comprehensive Database Performance Health Check
SQL SERVER – Removing Extra TempDB Files
The other day I ended up a very interesting situation while working with Comprehensive Database Performance Health Check, with TempDB files.
SQL SERVER – How to Shrink tempDB Database?
In the email yesterday from the client who earlier hired me for performance tuning had a small question about how to shrink tempdb database.
SQL SERVER – Dynamic SQL and Temporary Tables
Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.
SQL SERVER – Dynamic SQL and Global Temporary Tables
During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution
Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.