Skip to content

Database Maintenance Essentials – Resources

October 1, 2012

I told people in New York at SQL in the City that I’d post some resources on the blog from my talk. My apologies for not getting it done over the weekend, but during a little downtime in Austin I’m getting it done.

Checklist

From the last slide, a checklist of things for you to look at on your instances.

    • Backups scheduled on all database (full and log)
    • DBCC CHECKDB running regularly on all databases
    • Test restores scheduled
    • Manage mdf/ndf/ldf file sizes
    • Proactively monitor and maintain indexes and statistics
    • Monitor jobs and set up alerts

Challenge

At work, someday soon, but in the next 30 days, go through the checklist on your important servers, or all your production servers, and assess your maintenance.

Resources

From the slide deck, which will come soon in email. These are a list of links and resources from the talk.

 

About these ads

From → Blog

One Comment

Trackbacks & Pingbacks

  1. Comments on the SQL in the City Tour « Voice of the DBA

Comments are closed.

Follow

Get every new post delivered to your Inbox.

Join 4,768 other followers

%d bloggers like this: