How to find out important SQL Server service information using DMV?

Please use below code:

This code will inform us the service names, service account details, service status, start-up type, process id etc. This will also tell us if the service is clustered or not.


select * from sys.dm_server_services


Comments