SQL Server Services

You can monitor the following critical SQL services to determine whether the service is available (Up) or is disabled (Down).

Select this process:

To monitor this function:

MSSQLSERVER

This is the database engine. It controls processes all SQL functions and manages all files that comprise the databases on the server.

SQLSERVERAGENT

This service works with the SQL Server service to create and manage local server jobs, alerts and operators, or items from multiple servers.

Microsoft Search

A full-text indexing and search engine.

Distributed Transaction Coordinator

The MS DTC service allows for several sources of data to be processed in one transaction. It also coordinates the proper completion of all transactions to make sure all updates and errors are processed and ended correctly.

SQL Server Analysis Services

Implements a highly scalable service for data storage, processing, and security.

SQL Server Reporting Services

Used to create/manage tabular, matrix, graphical, and free-form reports.

SQL Server Integration Services

A platform for building high performance data integration solutions.

SQL Server FullText Search

Issues full-text queries against plain character-based data in SQL Server tables.

SQL Server Browser

Listens for incoming requests for SQL Server resources and provides information about SQL Server instances installed on the computer.

SQL Server Active Directory Helper

View replication objects, such as a publication, and, if allowed, subscribe to that publication.

SQL Server VSS Writer

Added functionality for backup and restore of SQL Server 2005.

See Also

Adding and editing a SQL Server 2000 monitor

Getting Started with SQL Server Monitors

SQL Server Parameters

Example: SQL Server Monitor