• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

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?
0
marrowyung
Asked:
marrowyung
  • 3
  • 3
1 Solution
 
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
 
marrowyungAuthor Commented:
then what should I look at ?

the most busiest DB system return nothing by that query .
0
 
marrowyungAuthor Commented:
I don't think that link tell enought information how that view.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
marrowyungAuthor Commented:
as I said, I don't understand that answer and can't see why it is related.
0
 
Eugene ZCommented:
<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

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now