The Details: QuickStart Training for Idera SQL Diagnostic Manager

3 Hours to Productivity

With 3 major areas of benefit:

  1. Installation and configuration (view)
  2. Alerts (view)
  3. Performance Tuning (view)

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