This topic has not yet been rated - Rate this topic

Monitoring (Database Engine)

SQL Server 2008 R2

Other Versions

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions