The Services tab allows you to view the status and manage your SQL Server services including the following services:
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.
SQL Diagnostic Manager provides two paths to access the Services tab. The first access path is by clicking the appropriate monitored SQL Server instance, 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.
The following alerts are associated with the Services tab:
The active node of the cluster is a non-preferred node. You can configure the preferred node under Server Properties > Cluster Settings.
There is a change in the active node. This alert remains active for the amount of time specified in the advanced settings for that alert.
Time in seconds that a replication transaction is holding at the Publisher and waiting for a Distributor.
Displays the status of the Distributed Transaction Coordinator service.
Displays the status of the Full-Text Search service.
The number of hours beyond which the Full-Text Catalog statistics data is considered outdated.
The number of transactions not written to the Distribution database.
Provides the status of the Agent Job Completion metric. Values for this alert include Succeeded, Retry, Canceled, Failed, and Unknown.
Indicates that a scheduled job processed by the SQL Server Agent service ended abnormally.
Provides the maximum number of minutes used to complete a scheduled SQL Server Agent job.
Indicates the percentage of time a scheduled job is using over what it normally uses to complete the job.
Displays the status of the SQL Server Agent service.
Displays the status of the SQL Server Active Directory Helper service.
Displays the status of the SQL Server Browser service.
Displays the status of the SQL Server service.
The number of non-subscribed transactions written to the Distribution database.
The number of seconds a transaction written to the database waits before subscription.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >