Back in 2009 Jonathan Kehayias wrote an article on SQL Server Central with the title “Retrieving Deadlock Graphs with SQL … Continue reading How to view a deadlock graph using the information from the default SQL Server 2008 system_health session?
Today I read an amazing post by Kendal Van Dyke. In the post he gives great news, he introduces SQLPowerDoc. … Continue reading Have you already tried sqlpowerdoc?
I have been asked many times on how to find the backup file location for a specific database, to be … Continue reading How to find the backup file location?
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?
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
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
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
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
A few days ago I got a question about the ideal value for “Extent Scan Fragmentation”. That is why I … Continue reading DBCC Showcontig and the ideal Extent Scan Fragmentation Value