What items are in your SQL Server Daily Checklist?

Hello everyone out there on the intertubes.  In my life I have learned that I can save a lot of time and energy by

First Annual SQL Rally is in May

First Annual SQL Rally is in May

utilizing checklists. The same is true with being a DBA.  I  manage over 100 instances of SQL Server. When my career started as a production DBA my head was spinning trying to track down failed jobs, missing backups and more on a daily basis. It could be done but it took quite a while and was a manual task. I needed to find a way to automate this process.  This is where Policy-Based Management and Central Management Server comes in. Now, I can sleep at night and just review my evaluated daily checklist first thing in the morning.

UPDATE [3/7/2011] : I added SQL Agent Notifications and Alerts as recommended in the comments. If you think an option is missing leave a comment and I will add it.

Help me Help you…

Just like Jerry Maguire I need your help.  I am speaking about Policy-Based Management and Central Management Server at the first annual SQLRally.  I need your input to help my presentation. I have two quick questions. It shouldn’t take you more than two minutes to complete the questions.  I appreciate your help and support.

[Note: Please make sure to click on the vote button for each question.]

What items are included in your Database Administration Daily Checklist?

View Results

Loading ... Loading ...

How do you evaluate your Database Administration Daily Checklist?

View Results

Loading ... Loading ...
  • I just voted in your polls, and I see an option missing from your second question – many of my checks are done via scheduled agent jobs that send me alerts only if a danger situation exists – like <10% free space on a disk, or certain errors have occured.
    This approach allows me to focus on the issues as they arrise and not worry about the 'noise'

  • Like Meredith, I do all my monitoring through scheduled jobs, some powershell, most are t-sql harvests to collected tables and then a reporting job runs on a server to send emails if I need them.

  • Thank you Meredith and Kevin for your feedback. I will add an option for SQL Agent Notifications and Alerts as an option for the second question. Kevin your solution is very close to what I do. More on this later 🙂

  • Hey John, we’ve got a lot of legacy jobs that are SQL Agent checks, and then a daily SSRS report comes out with the info we are looking at.

    We are also running PBM using EPMF from codeplex, hoping to replace the other with this one, but we have some reports we would need to re-create using the info we get from PBM

  • MattK (@HybridDBA)

    I marked 3rd party tool for #2, but I use a script that generates a report in HTML, e-mailed to me daily. This might be considered a “1st party” tool. I have also begun using Nagios to monitor specific system states more frequently.

  • MattK, Thank you for the input I added both Nagios and 1st Party tools as options to the second question.

  • SQLdm – Idera Diagnostic Manager is used on most production SQL Server instances, it is a great tool. We still have Notifications on most SQL Server Agent jobs to email certain individuals about failed and/or completed jobs. One BI Admin combines SQL Agent Jobs and Cognos Job Streams into one pdf file that is emailed daily.

    The Networking and IT Ops group use a variety of tools for OS and Free Disk (Solarwinds) and the EMC software handles performance monitoring on SANs.

    Confio’s Ignite8 is now used for Wait State monitoring on 4 production machines (BI and PeopleSoft).

    Thanks,
    Thomas (TheSmilingDB)

  • Hi Thomas,

    Thank you for your feedback. I am also a big fan of Ignite by Confio. PeopleSoft is the reason why we started using it. We now have it on three instances and hope to add more critical instances to Ignite this year.

    Regards,
    John

  • John – had your 2nd question allowed for multiple selections, I would also have included SQL Agent Notifications.