Get Your Money’s Worth from Your Read-Only Nodes with Round-Robin Routing
I was working on a four-node Availability Group migration and learned something new. Thanks to Brian Tanquary for showing me this trick. Without round-robin routing,…
Tag: SQL Server
SQL Server Content
-
-
Your Backup Job Succeeded. Your Backup Didn’t.
I keep seeing this problem. Jobs say success, but the backups are not usable.If backups are not your top priority, they should be. In many…
-
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…
-
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…