Monitoring (Database Engine)

This section contains information about monitoring the Database Engine.

In This Section

• 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.

See Also

Concepts

Monitoring Log Shipping

Other Resources

Monitoring Database Mirroring

Performance (Database Engine)