Versions Compared

Key

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

...

...

Image Added

Non-query activities data collection

You can select to collect non-query activities data using Extended Events (Use Extended Events radio button) or SQL Trace (Use SQL Trace radio button).  For instances running SQL Server 2012 or higher, the Activity 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, Extended Events.

...

Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

 

...