dm_os_performance_counters - Some values missing for some counters

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 1

Which rows are missing?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

JoseRocha Mr or Mrs. 500 Points: 574 More actions · Answer 2

Grant Fritchey (12/19/2013)
Which rows are missing?

I use this query to return the values, but two databases has no rows. The other databases has rows:

SELECT cntr_value

FROM sys.dm_os_performance_counters

WHERE counter_name = 'Transactions/sec'

AND object_name = 'SQLServer:Databases'

AND instance_name = '[database_name]'

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

That is odd. Any chance those databases are set to auto_close? If so, they won't have performance counter metrics.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

JoseRocha Mr or Mrs. 500 Points: 574 More actions · Answer 4

Really odd. Both databases has auto_close set to OFF.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 5

Then I'm not sure. You may need to contact Microsoft.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt