Skip to content

Instantly share code, notes, and snippets.

@ghotz
Created September 23, 2015 08:13
Show Gist options
  • Save ghotz/6312d9227e495aaa1f92 to your computer and use it in GitHub Desktop.
Save ghotz/6312d9227e495aaa1f92 to your computer and use it in GitHub Desktop.
Gather SQL Server services information
SELECT DSS.servicename,
DSS.startup_type_desc,
DSS.status_desc,
DSS.last_startup_time,
DSS.service_account,
DSS.is_clustered,
DSS.cluster_nodename,
DSS.filename,
DSS.startup_type,
DSS.status,
DSS.process_id
FROM sys.dm_server_services AS DSS;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment