Page History
...
- SQL Server Agent
- SQL Server Browser
- Full-Text Search (Note that SQL Server 2008 no longer has a separate full-text search service. If the monitored instance is SQL Server SQL Server 2008, the full-text search does not appear on the grid or graph.)
- DTC (Distributed Transaction Coordinator service)
- Replication services
| Tip |
|---|
The Start and Stop service actions are not supported for virtual SQL Server instances or instances located on a Windows cluster node. To start or stop a service on a virtual SQL Server 2008 instance, use the Microsoft Failover Cluster Management tool. For SQL Server 2005 or earlier, use the Microsoft Cluster Administrator tool to manage services. |
Access the Services tab
SQL Diagnostic Manager provides two paths to access the Services tab. The first access path is by clicking Access this tab by selecting the appropriate monitored SQL Server instance, server and then clicking the Services tab. The second access path is by expanding the Servers tree, and then clicking the Services for the appropriate instance.
Alerts associated with the Services tab
...
The active node of the cluster is a non-preferred node. You can configure the preferred node under under Server Properties > Cluster > Cluster Settings.
Cluster Failover
...
Time in seconds that a replication transaction is holding held at the Publisher and waiting for a Distributor.
...
The number of seconds a transaction written to the database waits before subscription.