Monitoring (Database Engine)

This section contains information about monitoring the Database Engine.

Monitoring Instances of SQL Server in the SQL Server Utility

Describes monitoring functionality in the SQL Server Utility.

Event Notifications (Database Engine)

Describes event notifications as a special kind of database object that can send information about server and database events to a service broker.

Log File Viewer (Object Explorer)

Describes the ways to display logged information about SQL Server components.

Monitoring Resource Usage (System Monitor)

Contains information about using Windows System Monitor to track resource usage in SQL Server.

Monitoring Events

Contains information about using SQL Server Profiler and SQL Trace to monitor SQL Server events.

Data Collection

Contains information about using the SQL Server data collector to obtain and save data that is gathered from several sources.

SQL Server Extended Events

Contains information about using SQL Server Extended Events, a general event-handling system for server systems.

SQL Server Profiler Reference

Contains information about using SQL Server Profiler to capture SQL Server events from an instance of the Database Engine. The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.