Getting Started Guide for SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server is a powerful performance monitoring and diagnostics solution that proactively alerts administrators to health, performance, and availability problems within SQL Server environments. Due to the depth and potential for customization of SQL Diagnostic Manager, it is possible to overlook features during the initial trial period. This text highlights often-missed and modifiable areas that give more complete control over management and reporting in SQL Server environments.

Read this getting started guide for SQL Diagnostic Manager for SQL Server to learn quickly about its benefits, permission requirements, architecture, capabilities, configuration, and first application.

Table of contents: Purpose of this document, Introduction, Why use SQL Diagnostic Manager, Permissions, Port requirements, Architecture, and Capabilities (Identify impact of slow-running queries, Analyze query performance, View session detail analytics, Alert predictively, Analyze prescriptively with expert recommendations, View past performance, Monitor tempdb, Plan future capacity, Connect to other tools, Access mobile console, Deploy web-based reports via SSRS, Adapt to specific needs, Audit activity, and Manage large environments)