SQL Server Error Log Tricks More DBAs Should Know
When SQL Server starts going down, one of the first places you should look is the error logs. They are the fastest way to pinpoint…
Tag: SQL Server
SQL Server Content
-
-
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…
-
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…