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