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
- Downloads
- 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
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.