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 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
Aaron Bertrand wrote a great post on DBCC CHECKDB. He advices on different ways on performing DBCC CHECKDB. His post … Continue reading A great post on DBCC CHECKDB
I just added SQLBits.com to my list of “SQL DBA Essential Links”. SQLBits is the largest SQL Server Conference in … Continue reading SQLBits
Since yesterday it is not a hard question to me anymore. I’m subscribed to many blogs (see my list of … Continue reading The best $97 you have ever spent?
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