Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

The sys.dm_xe_map_values, why it can see Reasons for Statement Recompilation

Dear all,

someone said this MS SQL SP, sys.dm_xe_map_values, can help to check out the reason of Statement Recompilation, how it can be done by that SP?
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

sys.dm_xe_map_values system view:
Returns a mapping of internal numeric keys to human-readable text.
http://technet.microsoft.com/en-us/library/bb630350.aspx

try:

SELECT d.name,d.map_key,d.map_value
FROM sys.dm_xe_map_values   d
WHERE d.name = N'statement_recompile_cause'
ORDER BY d.map_key

Open in new window

Avatar of marrowyung
marrowyung

ASKER

then what should I look at ?

the most busiest DB system return nothing by that query .
I don't think that link tell enought information how that view.
Can you please clarify your question?
You asked about the system view sys.dm_xe_map_values (BTW: it is not stored procedure )

The answer was provided.
No please tell what is the issue? what are you checking?
as I said, I don't understand that answer and can't see why it is related.
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial