Question about ISP billing procedures
Can anyone shed light on how ISPs handle missing samples when calculating p95s for monthly billing cycles? Do they fill null samples with zeros or leave them as null? I’m working on a billing sanity tool and want to make sure to cover my corner cases well. Thanks! Dan -- Thanks, Dan
Interesting question. How often are you missing data? I'd expect that to be pretty robust. On Wed, Feb 27, 2019, 10:33 PM Daniel Rohan <drohan@gmail.com> wrote:
Can anyone shed light on how ISPs handle missing samples when calculating p95s for monthly billing cycles? Do they fill null samples with zeros or leave them as null?
I’m working on a billing sanity tool and want to make sure to cover my corner cases well.
Thanks!
Dan -- Thanks, Dan
I can say that missing samples weren’t back filled when we billed. Never had any complaints. -Steve On Wed, Feb 27, 2019 at 10:31 PM Daniel Rohan <drohan@gmail.com> wrote:
Can anyone shed light on how ISPs handle missing samples when calculating p95s for monthly billing cycles? Do they fill null samples with zeros or leave them as null?
I’m working on a billing sanity tool and want to make sure to cover my corner cases well.
Thanks!
Dan -- Thanks, Dan
From my provider days if you miss data you can't bill it or assume zero.
Mike On Thu, 28 Feb 2019 at 15:06, Steve Meuse <smeuse@mara.org> wrote:
I can say that missing samples weren’t back filled when we billed. Never had any complaints.
-Steve
On Wed, Feb 27, 2019 at 10:31 PM Daniel Rohan <drohan@gmail.com> wrote:
Can anyone shed light on how ISPs handle missing samples when calculating p95s for monthly billing cycles? Do they fill null samples with zeros or leave them as null?
I’m working on a billing sanity tool and want to make sure to cover my corner cases well.
Thanks!
Dan -- Thanks, Dan
You have to zero it. -Ben
On Feb 27, 2019, at 8:10 PM, Michael Gehrmann <mgehrmann@atlassian.com> wrote:
From my provider days if you miss data you can't bill it or assume zero.
Mike
On Thu, 28 Feb 2019 at 15:06, Steve Meuse <smeuse@mara.org> wrote: I can say that missing samples weren’t back filled when we billed. Never had any complaints.
-Steve
On Wed, Feb 27, 2019 at 10:31 PM Daniel Rohan <drohan@gmail.com> wrote: Can anyone shed light on how ISPs handle missing samples when calculating p95s for monthly billing cycles? Do they fill null samples with zeros or leave them as null?
I’m working on a billing sanity tool and want to make sure to cover my corner cases well.
Thanks!
Dan -- Thanks, Dan
As per our village lawyer and accountant ... Assuming 95th percentile billing, sampling every 5 minutes. You'll need about 1.5days worth of 0 (~447 samples missing in a row) to bork the curve... and it goes the bith ways. If you're 5Gbps committed on a 10Gbps and you burst 10Gbs for 1.6 days, you pay for 10Gbps for that month. And yes that include the best effort to manage DDoS from both part. We're capitalist, but no one is from big pharma =D. ----- Alain Hebert ahebert@pubnix.net PubNIX Inc. 50 boul. St-Charles P.O. Box 26770 Beaconsfield, Quebec H9W 6G7 Tel: 514-990-5911 http://www.pubnix.net Fax: 514-990-9443 On 2/28/19 12:16 AM, Ben Cannon wrote:
You have to zero it.
-Ben
On Feb 27, 2019, at 8:10 PM, Michael Gehrmann <mgehrmann@atlassian.com <mailto:mgehrmann@atlassian.com>> wrote:
From my provider days if you miss data you can't bill it or assume zero.
Mike
On Thu, 28 Feb 2019 at 15:06, Steve Meuse <smeuse@mara.org <mailto:smeuse@mara.org>> wrote:
I can say that missing samples weren’t back filled when we billed. Never had any complaints.
-Steve
On Wed, Feb 27, 2019 at 10:31 PM Daniel Rohan <drohan@gmail.com <mailto:drohan@gmail.com>> wrote:
Can anyone shed light on how ISPs handle missing samples when calculating p95s for monthly billing cycles? Do they fill null samples with zeros or leave them as null?
I’m working on a billing sanity tool and want to make sure to cover my corner cases well.
Thanks!
Dan -- Thanks, Dan
Background: I used to own the code that was used to bill for awhile...
On Feb 27, 2019, at 11:10 PM, Michael Gehrmann <mgehrmann@atlassian.com> wrote:
From my provider days if you miss data you can't bill it or assume zero.
This was my experience as well. I remember a router vendor bug that if the traffic was low enough (idle) where the counters would go backwards(!!) meaning there were issues with the samples stored. I had to make a way to assume zero for missing samples as that wasn’t already in the codebase. It wasn’t hard, but was not in the code at the time. Make sure you store a zero value differently than a missed sample so you understand what that is/means. I still have some PTSD from those days :-) I recall people would come back and ask questions 3 months later, so keep all that stored data and poller logs so you can determine what happened. Even writing about it, I have the log messages showing up in my brain that described routers that were behaving poorly. - Jared
You can calculate the min and max by running it twice. Once with zero for missing values and once with max line speed. The true bill will be somewhere between min and max. If you are the ISP you would need to assume zero. You can only bill what you can prove. If you are the customer, you need to assume max. You can only claim excessive billing for what goes above what you can prove. Regards Baldur tor. 28. feb. 2019 04.32 skrev Daniel Rohan <drohan@gmail.com>:
Can anyone shed light on how ISPs handle missing samples when calculating p95s for monthly billing cycles? Do they fill null samples with zeros or leave them as null?
I’m working on a billing sanity tool and want to make sure to cover my corner cases well.
Thanks!
Dan -- Thanks, Dan
participants (9)
-
Alain Hebert -
Baldur Norddahl -
Ben Cannon -
Daniel Rohan -
Jared Mauch -
Michael Gehrmann -
Ross Tajvar -
Roy -
Steve Meuse