search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.18k stars 290 forks source link

Issue with Loading WhoisActive Results Due to Nested XML Nodes #119

Closed Imran-imtiaz48 closed 5 months ago

Imran-imtiaz48 commented 5 months ago

I have a job that loads the WhoisActive results into a table every 30 seconds. However, I encounter an issue when the XML SQL_TEXT contains too many nested nodes, making it impossible to load the table. Is there a way to filter these records or another workaround? Loading this data into a table has been invaluable in helping us solve numerous issues.

erikdarlingdata commented 5 months ago

This is a dupe of #111