Home > SQL Scripts, Uncategorized > sp_whoisactive cutomization

sp_whoisactive cutomization

We all mostly know about WhoIsActive custom stored procedure which give a full view of running sessions and much more based on parameter values.

Attached is the WhoIsActive_1 code in which I have done a bit of customization to have little more information

 

How to execute the Stored Procedure?

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

Code Sample :
use master
go
dbo.sp_WhoIsActive1 @get_plans=1, @get_transaction_info =1,@find_block_leaders=1,@get_locks=1

Attachment :WhoIsActive_1_Code

Categories: SQL Scripts, Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: