How can we help you today? How can we help you today?

How to decompress _queryText?

Hi everyeone, here in this forum a member asked how to decompress _queryText and another member called Alex B replied saying there is a script to decompress redgate _queryText. Does anyone have this script? 

This is on RedGateMonitor database. Table [data].[AzureManagedInstance_TopQueries_Instances] 
https://productsupport.red-gate.com/hc/en-us/community/posts/24970744138013--QueryText-Compression?page=1#community_comment_29381798696093

Pedro
0

Comments

1 comment

Sort by
  • Josh Head
    Official comment

    Hi there. I don't have the script mentioned, however in versions of SQL Server 2016 and later, you can do this: 

    SELECT CONVERT(VARCHAR(MAX), DECOMPRESS(CONVERT(VARBINARY(MAX), CONVERT(VARCHAR(MAX), _QueryText)))) FROM data.Cluster_SqlServer_TopQueries_Instances

    That should give you the same result. 

    Josh Head

Add comment

Please sign in to leave a comment.