_QueryText Compression

I am trying to do some analysis on our queries (specifically, long-running and blocking queries). I see in the forums in a number of places that the _QueryText column is compressed with GZIP compression. I am attempting to decompress it with no luck. Has something changed in more recent versions? Any chance someone could point me to something that could help me out with this? Thanks!
Tagged:

Answers

  • Nothing should have changed, though to preface this, we still cannot guarantee that it won't change.

    It should be the same as the DECOMPRESS() function in SQL Server 2016 and later.  I've attached a .sql script (renamed to .txt so I could attach it here) that will create a similar function to decompress.  It adds it in the utils schema of the SQL Monitor data repository.
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.