1 Reply Latest reply on Feb 3, 2012 1:03 PM by Andy McBride

SQL Rounding Issue between writer and web console

mezdem Feb 2, 2012 3:27 AM

I have a number of Availability reports which I am rounding to the 5th decimal place - so that I can determine the 'Nines' value accuratley,

The problem seems to be that the web console always rounds the value again. In sql I have a rounded Value of 99.99780% - when i then view that report via the web console it then rounds it again to 99.99810% and skews the statistics...

This glitch a known issue? can this be fixed... I know its only a differnece of 8 Seconds in Downtime - but every second counts these days!!

Re: SQL Rounding Issue between writer and web console

Andy McBride Feb 3, 2012 1:03 PM (in response to mezdem)

I don't believe that you can alter that rounding. I usually don't report availability at any more than four nines. The issue is that reporting to six or seven nines creates an expectation that the monitoring will detect very short outages on a per device basis.
Like (0)

Actions