Export (0) Print
Expand All

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.

Applies to: SQL Server (SQL Server 2008 R2 through current version).

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.

Value

Description

0

Other

1

Other

2

Automatic

3

Manual

4

Disabled

Is nullable.

startup_desc

nvarchar(256)

Describes the start mode of the service.

Value

Description

Other

Other (boot start)

Other

Other (system start)

Automatic

Auto start

Manual

Demand start

Disabled

Disabled

Cannot be null.

status

int

Indicates the current status of the service.

Value

Description

1

Stopped

2

Other (start pending)

3

Other (stop pending)

4

Running

5

Other (continue pending)

6

Other (pause pending)

7

Paused

Is nullable.

status_desc

nvarchar(256)

Describes the current status of the service.

Value

Description

Stopped

The service is stopped.

Other(start operation pending)

The service is in the process of starting.

Other (stop operation pending)

The service is in the process of stopping.

Running

The service is running.

Other (continue operations pending)

The service is in a pending state.

Other (pause pending)

The service is in the process of pausing.

Paused

The service is paused.

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.

Permissions

Requires VIEW SERVER STATE permission on the server.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft