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/

Advertisements

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)

PS