SQL server services

You can monitor the following critical SQL Server 2000 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.

See Also

Options

Configuring Email settings

Changing preferences

Managing dashboard views

Using the Program Options

Common SNMP traps

Event Viewer

Payload definition

Process list

Select computer

Select Device

Types of SNMP Trap monitors

WinEvent condition

FTP server user permissions

Setting Advanced Properties for a VoIP Monitor

Hub Transport Server Role Thresholds

Importing a MIB file

Selecting a blackout period

Select a device

Select computer

Setting Advanced Properties for a HTTP Content Monitor

Setting Advanced Properties for an Email Active Monitor

Setting Modem Connection Preferences

SMS Providers

Viewing the translation dialog

WMI

Change your password

Configure Network statistics threshold

Copy dashboard view

Copy dashboard view to a user

Edit dashboard view

New dashboard view

Select action type

Select Web Task Type

Setting Advanced Options

Editing a language