Database Maintenance Optimization

Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance, including:

  • Physical File Defragmentation
  • Database and Log File Management
  • tempdb Maintenance
  • msdb Maintenance
  • Index Maintenance
  • Statistics Maintenance
  • Data Corruption Detection
  • Database and Log File Protection
  • Database Maintenance Monitoring
Presented by Brad McGehee at SQLBits IV
  • Downloads
    Slide deck available Slide Deck 203 KB
    Video available WMV Video 252 MB
  • SpeakerBIO
    Brad M. McGehee is the Director of DBA Education for Red Gate Software and is an accomplished Microsoft SQL Server MVP with over 16 years SQL Server experience. Brad is a frequent speaker at SQL PASS, European PASS, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, and SQL Server user groups, where he shares his 16 years’ cumulative knowledge and experience.
  • Video