July 26, 2005 at 1:33 pm
When issuing the following query, I'm seeing negative numbers for my tempdb. (as well as zero values for master and model)
select database = a.instance_name
, 'dbcc log scans' = a.cntr_value
from master..sysperfinfo a
where a.object_name like '%Databases%' and
a.instance_name <> '_Total' and
a.counter_name = 'DBCC Logical Scan Bytes/sec'
order by 1
Any help would be appreciated. Thanks.
July 26, 2005 at 9:55 pm
Found this:
BUG: sysperfinfo counters are not time-adjusted (555064)
I'm wondering if you're getting these results because sysperfinfo has the raw values.
K. Brian Kelley
@kbriankelley
July 28, 2005 at 11:25 am
Interesting ... I ran the same query a few times and have a negative value on only 1 of 4 user databases for one randomly chosen server out of 25. The KB article states the raw coubnters are "monotonically increasing" and it is correct. The negative number(s) that you are seeing are increasing (getting nearer to zero).
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply