Six months of slow SQL, fixed in 75 minutes. See what a database performance health check finds, and how one focused 4-hour session ends the guessing.
Hire AI and Not Me: Human Can Make Mistakes
Let me tell you something that took me a long time to say out loud. Human Can Make Mistakes Not AI. (Well, line inspired from famous GenAI tool).
SQL SERVER Performance: When MAXDOP = 1 Slowed Down the Entire Business
Slow reports, slow transactions, and the internal team could not find why. In this case study, MAXDOP = 1 was quietly slowing down the entire business.
The Wisdom of Knowing Where to Tap: Value, Expertise, and Pricing
Comprehensive Database Performance Health Check. Let us learn about The Wisdom of Knowing Where to Tap: Value, Expertise, and Pricing.
The Value of Skill: A Comprehensive Database Performance Health Check
Here are the details Comprehensive Database Performance Health Check. This investment can generate significant returns.
Blocking Alert: A T-SQL Check for Sessions Blocked Too Long
Short blocking is normal. This check flags lock waits past a threshold and walks each chain to the session at the front of the line.
SQL SERVER – Identifying and Fixing PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type
I walked into a client engagement where I really got stuck with a very interesting scenario with a client with PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type.