Tag Archives: SQL Services

How to monitor SQL Server Services of multiple instances?

Problem:
I have a need to monitor the SQL Server Services in my environment. Are there any programmatic options to do so? Check out this tip to learn more.

Solution:
http://www.mssqltips.com/sqlservertip/2867/steps-to-monitor-the-sql-server-services/

sys.dm_server_services

sys.dm_server_services DMV is available in SQL Server 2008 R2 SP1 and SQL Server 2012. It will return the information about the below SQL Services on the current instance.

SQL Server (2008 R2 SP1 and SQL Server 2012)
SQL Server Agent services(2008 R2 SP1 and SQL Server 2012)
Full-Text(SQL Server 2012)