[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

more ▼

asked Sep 19, 2011 at 07:01 AM in Default

avatar image

6.6k 21 26 34

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

Sep 19, 2011 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, 2011 at 07:34 AM WilliamD

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

Sep 19, 2011 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, 2011 at 09:08 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

The question has been closed Oct 07, 2011 at 05:13 AM by Shawn_Melton for the following reason:

0 answers: sort voted first

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 19, 2011 at 07:01 AM

Seen: 1612 times

Last Updated: Sep 19, 2011 at 07:01 AM

Copyright 2018 Redgate Software. Privacy Policy