Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Database Maintenance Essentials – Resources

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.

 


Filed under: Blog Tagged: administration, presentations, sql server, syndicated

Comments

Leave a comment on the original post [voiceofthedba.wordpress.com, opens in a new window]

Loading comments...