What Causes Locking and Blocking and When to Take Action
It’s common to see a lock and immediately assume it’s the problem. Many people believe that any lock is a bad thing. I’ve had to…
Category: Databases
Database content
-
-
The Ultimate Checklist for Jr DBAs
As I reflect on my journey as a DBA, I realize how much the landscape has shifted over the years. With the rise of cloud…
-
SQL Server Memory Grants: Exposing the Silent Performance Assassin
Part 1 Memory Grant Introduction If you’ve been dealing with performance issues, you’ve probably focused on logical reads,duration, CPU usage, and other metrics. However, with…