x

[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][2] 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

[2]: https://connect.microsoft.com/SQLServer/SearchResults.aspx?SearchQuery=sys.dm_server_services
more ▼

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

Shawn_Melton gravatar image

Shawn_Melton
5.3k 19 21 29

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x22
x5

asked: Sep 19, 2011 at 07:01 AM

Seen: 1255 times

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