Collecting the SQL Diagnostics Information

To collect SQL diagnostics information and to configure or deconfigure SQL server monitors, use the Diagnostic Monitors for SQL Server workflow.

Procedure

1. Execute the Diagnostic Monitors for SQL Server workflow.

   For information about executing workflows, see Running Workflows from the CommCell Console.

2. In the Monitor name box, select the SQL extended event that you want to monitor. The workflow supports the following SQL extended events:

   • TempDB Monitor: Collect the diagnostic data for tempdb growth.

   • Deadlock Monitor: Collect the diagnostic data for detected SQL deadlocked queries.

   • SP Stats Monitor:Collect the diagnostic data from SQL Server Stored Procedure system table cache specific to the selected databases.

3. In the Operation Type box, select the option to either configure or deconfigure the monitor.

4. If you select the SP Stats Monitor SQL extended event, complete the following:

   1. From the SP Stats: Database list, select the database that you want to monitor.

   2. From the SP Stats: Collection Type list, select the type of data that you want to collect. For example, High CPU Usage or Elapsed Time.

5. Click OK.