Page History
...
You can select to collect query data using Extended Events (collect query data using Extended Events radio button) or SQL Trace (Collect query data using SQL Trace radio button). For instances running SQL Server 2008 or higher, the Query Monitor uses by default Extended Events. First introduced in SQL Server 2008, Extended Events provide a new mechanism to capture information about events inside the Database Engine and diagnose performance problems. This functionality is highly efficient and lightweight. For more information about using Extended Events, see the Microsoft document,
. Newtablink alias Extended Events url http://msdn.microsoft.com/en-us/library/bb630282.aspx
...
To capture query data for monitored pre-SQL Server 2008 instances, enable the SQL Trace collection option. Note that enabling this option can degrade performance on your SQL Server.
Warning | ||
---|---|---|
| ||
Collecting query data using SQL Trace does not allow for the collection of query plans, resulting in a disabled Collect Query Plans (SQL Server 2008 and up only) check box. |
Anchorqueryexecplans queryexecplans
Query Execution Plans collection
queryexecplans | |
queryexecplans |
...
You can choose to collect or not query execution plans by clicking the Collect Query Plans (SQL Server 2008 and up only) check box in the Query Monitor window. For instances running SQL Server 2008 or higher, this option is enabled by default.
...
For pre-SQL Server 2008 versions, Query Execution Plan capturing is not available.
Note |
---|
Selecting the Collect query data using SQL Trace option, disables the Collect Query Plans ( for pre-SQL Server 2008 versionsand up only) check box. |
Anchorcaptpoorlyperfqueries captpoorlyperfqueries
Capturing poorly-performing queries
captpoorlyperfqueries | |
captpoorlyperfqueries |
...