Why Every Byte Matters for SQL Server Pages
Think of a SQL Server data page as a Delta carry-on suitcase. It is always the same size, 8 kilobytes. When people talk about making…
Tag: SQL Server
SQL Server Content
-
-
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…
-
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…