By the time you complete this module, you should be able to:
- Monitor the size of a database
- Monitor the size of a database with SQL-EM
- Use dbcc to monitor databases
- Monitor the consistency of individual tables
- Perform the miscellaneous database monitoring with dbcc
- Monitor the transaction log
- Maintain statistics
- View statistics information
- Run sqlmaint.exe
- Use the Database Maintenance plan Wizard
The next lesson will cover how databases free space.