Home Dashboard Directory Help
Search

Add OPTION(LABEL = 'some text') Hint to SMP Product by Dan Guzman


Status: 

Active


30
0
Sign in
to vote
Type: Suggestion
ID: 833055
Opened: 3/12/2014 6:53:13 PM
Access Restriction: Public
0
Workaround(s)
view

Description

The OPTION (LABEL...) query hint currently exists, but is ignored except in PDW queries. In PDW, the specified label is visible in the monitoring console, making it easy for a DBA to identify the purpose of a query with the option specified. A query label is particularly useful in monitoring multi-step, long-running processes.
Details
Sign in to post a comment.
Posted by Itzik Ben-Gan on 4/17/2014 at 9:10 PM
Totally agree with Paul. Would be great to see the label exposed in DMVs.
Posted by Paul White NZ on 4/17/2014 at 5:57 PM
This is a great suggestion. Having the label exposed as a column in different DMVs would allow more efficient filtering of interesting queries. Currently, we have to search the entire plan cache using sys.dm_exec_sql_text with a LIKE filter.
Sign in to post a workaround.