Loading...

Collecting Query Performance Data Using Workflows

You can collect data about query performance for queries running on the CommServe database using predefined workflows in the CommCell Console. After the data is collected, you can analyze it to troubleshoot problems.

Downloading the Stored Procedure

Before you can use workflows to collect query performance data, you must download the Who is Active procedure.

The DBMaintenance utility uses a third-party stored procedure called Who is Active to collect query performance data. The Who is Active stored procedure is available on the sp_whoisactive website.

Go to sp_whoisactive Downloads and download the latest version of the Who is Active stored procedure. Review the author's copyright agreement. On the CommServe computer, in the SQL Server Management Studio (SSMS), in the master database, install and execute the Who is Active script. For instructions about how to execute a stored procedure in SSMS, on the Microsoft documentation website, see Execute a Stored Procedure.

Procedure

Running a Who Is Active (WIA) Tracer Job from the Diagnostic WIA Tracer Stup Workflow

  1. Execute the Diagnostic WIA Tracer Setup workflow.

    For information about executing workflows, see From the CommCell Console.

  2. From the WIA Tracer Configuration list, do one of the following:
    • To run the job for a specific number of days, select the number of days to run the job.
    • To run the job continuously, select Forever.

    The WIA Tracer job runs every fifteen minutes for the duration you configured.

    Tip: If you want to run the WIA Tracer job at a different interval, follow the procedure to Collecting Query Performance Data Using the Command Line.

Stopping a Who Is Active (WIA) Tracer Job from the Diagnostic WIA Tracer Deletion Workflow

  • Execute the Diagnostic WIA Tracer Deletion workflow.

    For information about executing workflows, see From the CommCell Console.

Last modified: 4/18/2019 1:50:15 PM