Today I want to share one script that I use very frequently through Central Management Server to monitor the SQL services current running status.

This script will work from SQL Server 2008R2 SP1 onward as DMV dm_server_services was introduced from 2008R2 SP1.

Below is the script:

SELECT dss.[status_desc],servicename,startup_type_desc,service_account
FROM sys.dm_server_services dss
WHERE dss.[servicename] LIKE N’SQL%’


Hopefully this will be useful for you in monitoring your inventory.


Subhro Saha