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. 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.

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

Zobacz także

Odwołanie

sys.dm_server_registry (Transact-SQL)