SAP Sybase SQL Anywhere Accessing Client Billing Information
Module 11 – Accessing Client Billing Information
In this module, you will learn how to retrieve and read billing metrics for your SAP Sybase SQL Anywhere, on-demand edition cloud. The billing metrics contain usage information that is updated every hour. The usage information includes metrics such as consumption of processing resources and online time during a given period.
Your cloud should have the basic architecture set up with at least a few tenant databases active and running.
Counters for Billing Metrics
Tenant database usage metrics are determined using counters, which can be system-defined or user-defined. System-defined counters include totalRequestsReceived, averageNumConnections, and averageTotalFileSize, which count the total number of requests, the average number of active connections, and the average size of all dbspaces, respectively, within a billing period.
User-defined counters are counters that you can set yourself to count events of your choice. For an example and more information about how counters determine usage metrics, visit the documentation site at http://dcx.sybase.com/index.html#cloud100/en/dbcloud/cloud-billing.html.
Viewing Billing Metrics
Usage information from the counters is updated every hour and a usage summary report can be generated to view the billing metrics. There are two options for retrieving the usage summary report, downloading the file to store locally or viewing the report in a browser. The report can also be generated in two different formats, XML and CSV.
When generating reports, you need to specify the parameters for the report.
|resolution||Billing period unit (hour, day, week, month, quarter, year)|
|start||Start time/date for usage report|
|stop||Stop time/date for usage report|
|database||Database for which to generate report|
|tag||Tags for which to generate report|
|format||Format of report (CSV, XML)|
|filename||File to output usage report to when downloading|
To download the usage summary report, you will use the Cloud Command utility in the command prompt or terminal of a cloud host. Run a command, replacing the parameters:
dbcloudcmd download "op/usage?<report-parameters>" <local-directory\filename>
To view the usage summary report in a browser, go to this address:
The following is an example of using the Cloud Command utility, using ampersands to separate multiple parameters:
dbcloudcmd download "op/usage?start=2011-01-01&stop=2011-12-31&resolution=day&format=CSV" C:\usagereport.csv
This will produce a comma-separated values (CSV) file that can be viewed in a text editor or a spreadsheet.
If an XML format was chosen, then the file will output the data in XML form which you can read in a browser.
For more information on these parameters and how to use them, visit the billing documentation site at http://dcx.sybase.com/index.html#cloud100/en/dbcloud/cloud-billing.html.