Versions Compared

Old Version 2

changes.mady.by.user Unknown User (6092b4dfd35380006886a5fb)

Saved on

compared with

New Version 3

changes.mady.by.user Unknown User (6092b4dfd35380006886a5fb)

Saved on

Key

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

...

Note

To capture query data for monitored pre-SQL Server 2008 instances, enable the SQL Trace collection option.  Note that enabling implementing this option does not allow for the collection of query plans (disabling the Collect Query Plans check box) and can degrade performance on your SQL Server.

...

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 for pre-SQL Server 2008 versions and when you select the Collect query data using SQL Trace option, disables the Collect Query Plans (SQL Server 2008 and up only) check box.

Anchor
captpoorlyperfqueries
captpoorlyperfqueries
Capturing poorly-performing queries

...