Identify a trivial plan in SSMS and cached XML, understand skipped optimizer work, and compare a more complex query without forcing it.
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.
Removing a Bad Plan From Cache Without Clearing Everything
Remove one bad plan from cache by handle, compare narrower recompilation choices, and fix the cause so the plan stays healthy.
SQL SERVER – 5 Performance Optimizations Must Do for TempDB
Great hardware, bad performance, and TempDB was the culprit. Here are 5 performance optimizations must do for TempDB, starting with pre-sizing it.
SQL SERVER – Increasing Speed of CHECKPOINT and Best Practices
I received this question as a follow up of my earlier blog post which I wrote about SQL SERVER – Impact of CHECKPOINT and DBCC DROPCLEANBUFFERS on Memory.
SQL SERVER – Clean Pages and Dirty Pages Count – Memory Buffer Pools
Recently, while working with the customer who had a Memory issue, we ended up talking about Clean Pages and Dirty Pages Count.
SQL SERVER – Natively Compiled Stored Procedures and Location of Compiler
I recently implemented a Memory Optimized Table solution at one of the large financial organizations while working on Natively Compiled Stored Procedures.