Loading...

Downloading the Who is Active Stored 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. Before you can use workflows to collect query performance data, you must download the Who is Active procedure.

Procedure

  1. Go to sp_whoisactive Downloads and download the Version 11.20 of the Who is Active stored procedure.

    Review the author's copyright agreement.

  2. 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.

Last modified: 6/16/2020 1:43:46 PM