SQL Server Services information

SELECT servicename
	,process_id
	,startup_type_desc
	,status_desc
	,last_startup_time
	,service_account
	,is_clustered
	,cluster_nodename
	,[filename]
	,instant_file_initialization_enabled
FROM sys.dm_server_services WITH (NOLOCK)
OPTION (RECOMPILE);

Microsoft help

Spread the love