Optional Components
sp_WhoIsActive
SQLWATCH can log output from Adam Machanic's, fantastic sp_WhoIsAcitve
which can also be installed using dbatools:
Install-DbaWhoIsActive -SqlInstance YourServer -Database master
SQLWATCH will look for sp_WhoIsActive
in either the master database or the database where the SQLWATCH is installed (default SQLWATCH but it could any database)
Install-DbaWhoIsActive -SqlInstance YourServer -Database SQLWATCH
Last updated