sp_whoisactive filtering

  • I am experiencing difficulty filtering the results in the sp_whoisactive stored procedure when attempting to apply multiple filters. Can someone please provide assistance or guidance?

    Attachments:
    You must be logged in to view attached files.
  • Thanks for posting your issue and hopefully someone will answer soon.

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

  • any updates from anyone?

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

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