3 Hours to Productivity
With 3 major areas of benefit:
Installation and Configuration
Review installation and configuration of Diagnostic Manager
- Discuss SQL Server architecture
- Discuss Diagnostic Manager architecture & installation options
- Review current Diagnostic Manager deployment
Set up Diagnostic Manager server groups
- Discuss organizing servers into groups within Diagnostic Manager for specific purposes
- Demonstrate how to set alerts based on the groups
Configure trace settings for monitored servers
- Demonstrate use of SQL trace feature
Create security groups
- Demonstrate how to set up security groups
Alerting
Explain establishing baselines for monitored servers
- Discuss and Demonstrate how to set baselines
Set alert thresholds for each monitored server
- Demonstrate how to set up alerts
- Review best practices for the critical alerts
- Set up alerts based on best practices on one server
- Review how to make decisions regarding alerts
Create notification rules in response to alerts
- Demonstrate how to create notifications
- Review best practices
- Set up notifications in response to alerts on one server
Create custom counters
- Explain and demonstrate the use of custom counters
Schedule reports
- Review reports and their purposes in Diagnostic Manager
- Discuss best practices
- Demonstrate scheduling reports using SQL Reporting Services
Performance Tuning
Identifying and Resolving Problems
- Discuss and demonstrate how to resolve SQL problems:
- Resolve blocking and deadlocking issues
- Identify sessions that use most resources & resolve issues
- Identify worst performing queries
- Analyze space utilization
- Utilize wait statistics
- Use reports to analyze trends
