You can monitor the following critical SQL services to determine whether the service is available (Up) or is disabled (Down).
Select this process: |
If you want to: |
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. |