sp_whoisactive filtering

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80342 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Abhishek SSCommitted Points: 1715 More actions · Answer 2

SSCommitted

Points: 1715

June 19, 2024 at 8:20 am

any updates from anyone?

Phil Parkin SSC Guru Points: 247149 More actions · Answer 3

Not a direct solution, but have you considered creating a temp table to hold the results of running sp_whoisactive, then doing an

INSERT #SomeTable
EXEC sp_whoisactive

followed by whatever filtering you require? If it's something you do often, assign the entire thing to a KB shortcut.

SteveOC Ten Centuries Points: 1259 More actions · Answer 4

I have a similar (same) issue.

It says on the online docs that the filters are 'additive' but when I try to filter on 2 values it errors.

I want to ONLY see SPIDs from a specific HOST with a specific LOGIN - but I can't seem to do that.

Adding two filters in the exec generates an error because I specify the @filtertype twice with the 2 different values.

So what does 'additive' mean - can you specify multiple filters for the same filter type but not multiple filter types maybe?

SteveOC Ten Centuries Points: 1259 More actions · Answer 5

sp_whoisactive: Capturing the Output

I think that this shows why Phil's suggestion won't work sadly but may provide a solution for me.

webrunner SSC-Dedicated Points: 31970 More actions · Answer 6

Hi, have you tried this page?

HTH

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html