sp_whoisactive

How to execute sp_whoIsActive?

Create the procedure in master database.Execute the procedure from Query Analyser as below.

Code Sample :

use master
go
dbo.sp_WhoIsActive @get_plans=1, @get_transaction_info =1,@find_block_leaders=1,@get_locks=1

Attachment :WhoIsActive.sql

Leave a Reply

Your email address will not be published. Required fields are marked *