One of the most important steps in setting up SQL Diagnostic Manager to successfully monitor your SQL Server instances is the configuration of your alerts so that you only receive alerts on metrics that actually fall outside the typical performance of your environment.

SQL Diagnostic Manager allows you to do this by letting you set a period of time where the metric ranges collected for a set of alerts help determine your alert thresholds. After data collection begins, SQL Diagnostic Manager gives you recommendations for tweaking your alert thresholds for the following metrics:

  • Blocked Sessions (Count)
  • Client Computers (Count)
  • Custom Counters
  • OS Average Disk Queue Length (Count)
  • OS Disk Time (Percent)
  • OS Memory Usage (Percent)
  • OS Paging (Per Second)
  • OS Privileged Time (Percent)
  • OS Processor Queue Length (Count)
  • OS Processor Time (Percent)
  • OS User Time (Percent)
  • Page Life Expectancy
  • SQL Server CPU Usage (Percent)
  • SQL Server Response Time (Milliseconds)

To configure your alert thresholds:

  1. Configure the performance baseline.
  2. As your performance baseline period ends, text appears at the top of your Alert Configuration window regarding available recommendations. Click the Alert Recommendation text to open the Alert Recommendations window for your SQL Server instance. This window allows you to see the thresholds SQL Diagnostic Manager recommends based on the data collected during your performance baseline
  3. Either apply the alert recommendations or tweak your thresholds.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >