Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nicolas Rios

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These query performance metrics are collected from the Dynamic Management View (DMV) sys.dm_exec_query_stats. For more information about individual metrics, see the corresponding Microsoft Developer Network (MSDN) article (httpMicrosoft article

Newtablink
aliassys.dm_exec_query_stats (Transact-SQL)
urlhttps://msdn.microsoft.com/en-us/library/ms189741.aspx
)
.

However, the Query column displays the T-SQL code executed by the query, and the Count column reports how many times the query was run.

Access the Query Plan Stats view

You can access the Query Plan Stats view for a SQL Server instance by expanding the directory tree for the instance, and then selecting Query Plan Stats.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
| 

...

SQL Doctor provides complete SQL performance tuning. Learn more > >

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
| 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...