Advertisements
Home > Dynamic Management Views/Functions, SQL 2008 > Execution Related Dynamic Management Views and Functions Differences

Execution Related Dynamic Management Views and Functions Differences

sys.dm_exec_query_stats

SQL 2008: Added two new fields the the DMV (query_hash and query_plan_hash); designed to help performance tune queries with similar logic, you can read more about it at this link.

sys.dm_exec_sql_text

SQL 2008: The handle can now be also be from the sys.dm_exec_connections DMV; before it was from sys.dm_exec_query_stats, sys.dm_exec_requests, sys.dm_exec_cursors, sys.dm_exec_xml_handles, sys.dm_exec_query_memory_grants DMV only.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: