[Closed] sys.dm_server_services

Anyone else try to query sys.dm_server_services and get funny results?

I actually get 2 rows returned on one of my servers and both rows are for the SQL Server Service. Where it should be row for the SQL Server service and SQL Server Agent. I was going to submit a connect item for it, if other folks are having the same results.

I checked Connect and there are 3 submissions that reference this DMV by Aaron Bertrand, but none of them reference not getting Agent Service returned at all. He does have one where he returned 3 rows, 2 being for SQL Agent but that was with SQL Denali CTP3.

SELECT servicename, startup_desc, status_desc, last_startup_time FROM sys.dm_server_services

asked Sep 19 '11 at 07:01 AM in Default

Shawn_Melton
4.7k ● 13 ● 17 ● 27

Hmmm.. fine for me (build 10.50.2500.0 (X64))

Sep 19 '11 at 07:08 AM Kev Riley ♦♦

Not a problem for me, I'm on CTP3 and get 3 entries: SQL Server, SQL Agent and FullText Indexing

Sep 19 '11 at 07:34 AM WilliamD

just checked another instance at same build and it is normal results.

Sep 19 '11 at 07:39 AM Shawn_Melton

Out of interest, does anyone have a downloaded version of BOL that includes this? It is on MSDN (as linked to by Shawn), but the latest BOL I've just downloaded doesn't have it !?!?!?

Sep 19 '11 at 09:08 AM Kev Riley ♦♦

(comments are locked)