February 8, 2012 at 7:51 pm
I am logging performance monitor data to a database and attempting to graph it through a report I created in Report Builder 3.0. The line graphs do appear and they do show the trends for the various performance counters. One of the graphs displays disk latency. When I query the database directly I can see that there was a row with a value of 895(ms) but when I look at the graph I do not see that spike on the graph. If I export that data to Excel and graph it, the graph accurately shows this spike. I have been unable to determine the reason for this. This happens across multiple line graphs but more so for values with larger fluctuations such as per second performance counters(avg disk sec/write or disk writes/sec). Has anyone else seen this behavior or can explain why this happens?
February 9, 2012 at 7:12 am
Could the scale of your graph be responsible for flattening the spikes?
February 9, 2012 at 9:31 am
The axis options are all default which are all auto for the axis range and interval settings and no options are enabled in the scale options. I'm not sure if there are other scaling options to check in Report Builder.
Daniel Bowlin (2/9/2012)
Could the scale of your graph be responsible for flattening the spikes?
February 9, 2012 at 1:05 pm
I finally resolved my issue. I was using the following expression for session properties value field which was not providing me accurate graph data.
=Fields!CounterValue.Value
After changing the expression to the following, the graphs are now displaying accurate data.
=Max(Fields!CounterValue.Value)
Thanks,
Jason
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply