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.
Concepts
Other Resources