SQL Server Essentials for Oracle DBAs: (15) Monitoring

Module 15 shows the mechanisms by which the database can be monitored for availability, errors, and performance. Statistics that can be captured for both proactive and reactive administration of the databases are reviewed here.

• [03:59] - Error logs
• [10:50] - Error messages
• [19:50] - Monitoring performance
• [28:17] - Activity monitor

Full course outline:

• Mod 01: Database and Instance
• Mod 02: Database Architecture
• Mod 03a: Instance Architecture Part 1
• Mod 03b: Instance Architecture Part 2
• Mod 04: Data Objects
• Mod 05: Data Access
• Mod 06: Data Protection
• Mod 07: Basic Administration
• Mod 08: Server Management
• Mod 09: Schema Management
• Mod 10: Database Security
• Mod 11: Data Movement
• Mod 12: Backup and Recovery
• Mod 13: Performance Tuning
• Mod 14: Scalability and High Availability
• Mod 15: Monitoring