Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005
Yesterday I was trying to remember a bug in SQL Server 2005 log shipping when using the secondary database for reporting. As most of you may know in order to use the secondary database for reporting, the database must be recovered with standby. A very long time ago when SQL Server 2005 was supported , [...]
How to include your Central Management Server in your CMS registered Servers group?
I have been using Central Management Servers(CMS) for quite some time now and I think CMS are a essential tool for a DBA. Brent Ozar wrote a blog about CMS back in 2008, you can find his blog here. Brent mentions in that blog that one of the limitations of CMS is that it can’t [...]
How to view a deadlock graph using the information from the default SQL Server 2008 system_health session?
Back in 2009 Jonathan Kehayias wrote an article on SQL Server Central with the title “Retrieving Deadlock Graphs with SQL Server 2008 Extended Events”. It is a very handy article, it explains how to obtain deadlock information from a SQL Server 2008 or higher version without enabling a trace flag. The only thing I was [...]
Have you already tried sqlpowerdoc?
Today I read an amazing post by Kendal Van Dyke. In the post he gives great news, he introduces SQLPowerDoc. I can’t wait to give it a try. Please take the time to read Kendal’s blog post and let me know what do you think of ” SQLPowerDoc”. You can find his post on his [...]
How to find the backup file location?
I have been asked many times on how to find the backup file location for a specific database, to be honest I always forget the name of the table I need to join to “backupset” and end up looking for the table name on the MSDB database to find the backup file location. I think [...]
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 CPU speed on our SQL Servers. In a perfect world we should not do it, but since the world is not perfect I will advice you to do so. This advice is not new, Brent [...]
SQL Server Virtual Labs
One of the things that surprise me a lot is how little known are the Microsoft SQL Server Virtual Labs. Sometime ago I blogged about it, back then SQL Server 2012 was not released. If you would like to try some of the new features of SQL Server, the virtual labs are something for you. [...]
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 I going to do the same with the latch query that Paul Randal posted is his blog “Most common latch classes and what they mean”. I slightly modified Paul’s query. adding information on the latch [...]
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 dashboard is a great way to troubleshoot your SQL Servers, when SQL Server 2008 was introduced the performance dashboard didn’t word on it anymore and it was recommended to use the new activity monitor or [...]
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 “wait-statistics-or-please-tell-me-where-it-hurts”. I check it very often and whenever you google a waittype you are most likely to get the link to his post in the top ten. In his post Paul provides a modified version [...]
Recent Comments