sys.dm_server_services (Transact-SQL)
Returns information about the SQL Server, Full-Text, and SQL Server Agent services in the current instance of SQL Server. Use this dynamic management view to report status information about these services.
|
Column name |
Data type |
Description |
||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
servicename |
nvarchar(256) |
Name of the SQL Server, Full-text, or SQL Server Agent service. Cannot be null. |
||||||||||||||||
|
startup_type |
int |
Indicates the start mode of the service.
Is nullable. |
||||||||||||||||
|
startup_desc |
nvarchar(256) |
Describes the start mode of the service.
Cannot be null. |
||||||||||||||||
|
status |
int |
Indicates the current status of the service.
Is nullable. |
||||||||||||||||
|
status_desc |
nvarchar(256) |
Describes the current status of the service.
Cannot be null. |
||||||||||||||||
|
process_id |
int |
The process ID of the service. Cannot be null. |
||||||||||||||||
|
last_startup_time |
datetimeoffset(7) |
The date and time the service was last started. Is nullable. |
||||||||||||||||
|
service_account |
nvarchar(256) |
The account authorized to control the service. This account can start or stop the service, or modify service properties. Cannot be null. |
||||||||||||||||
|
filename |
nvarchar(256) |
The path and filename of the service executable. Cannot be null. |
||||||||||||||||
|
is_clustered |
nvarchar(1) |
Indicates whether the service is installed as a resource of a clustered server. Cannot be null. |
||||||||||||||||
|
cluster_nodename |
nvarchar(256) |
The name of the cluster node on which the service is installed. Is nullable. |
