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?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
<The sys.dm_xe_map_values, why it can see Reasons for Statement Recompilation>?

again: because of it is System sql server view that shows info based on the collected from last restart detail. It is how sql server works

Dynamic management views and functions return internal, implementation-specific state data. Their schemas and the data they return may change in future releases of SQL Server.
http://technet.microsoft.com/en-us/library/ms188754.aspx

----
0
 
Eugene ZCommented:
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

0
 
marrowyungSenior Technical architecture (Data)Author Commented:
then what should I look at ?

the most busiest DB system return nothing by that query .
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
marrowyungSenior Technical architecture (Data)Author Commented:
I don't think that link tell enought information how that view.
0
 
Eugene ZCommented:
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?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
as I said, I don't understand that answer and can't see why it is related.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.