Easy way to get status of SQL Server Services in SQL 2012

SQL 2012 has some new DMVs.
One of them is sys.dm_server_services
It gives us details about the SQL Server services (SQL Serve,SQL Server Agent, Full Text)





SELECT *
FROM   sys.dm_server_services


No comments:

Post a Comment

Popular Posts