Have you checked your SQL Server CPU speed lately?
One of the things we usually forget as DBAs is that we need to check from time to time the … Continue reading Have you checked your SQL Server CPU speed lately?
SQL Server Virtual Labs
One of the things that surprise me a lot is how little known are the Microsoft SQL Server Virtual Labs. … Continue reading SQL Server Virtual Labs
Paul Randal’s Most common latch classes and what they mean
Some days ago I wrote a post where I added a query with the description on the wait types. Today … Continue reading Paul Randal’s Most common latch classes and what they mean
SQL Server 2008 performance dashboard and SQL Server 2012 performance dashboard
In 2009 I wrote about fixing problems with the performance dashboard for SQL Server 2005. The SQL Server 2005 performance … Continue reading SQL Server 2008 performance dashboard and SQL Server 2012 performance dashboard
Paul Randal’s wait-statistics-or-please-tell-me-where-it-hurts
One of the best posts you can find on internet about the “waits and queues” Troubleshooting methodology is Paul Randal’s … Continue reading Paul Randal’s wait-statistics-or-please-tell-me-where-it-hurts
How to access the SQL Server Configuration Manager using registered servers
A few days ago I was talking to my friend Roman Bondar about how handy is to use the SQL … Continue reading How to access the SQL Server Configuration Manager using registered servers
2012 in review
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: 600 people reached the … Continue reading 2012 in review
