Expand size of LABEL in query logs
The LABEL column in the sys.dmpdwexec_requests DMV is limited to 255 characters.
This field needs to be much larger to store rich metadata/context of some queries.
Thank you for all the feedback folks. Unfortunately this is taking longer than we’d like. We will reach back out when it is on the roadmap and can share when we have an update.
Have you seen the new Query Store feature? This enables many of the scenarios around query retention.