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
-
Go to sp_whoisactive Downloads and download the Version 11.20 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.