Skip to Content
SAP SQL Anywhere

SAP Sybase SQL Anywhere Accessing Client Billing Information

Tags:

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.

Pre-requisites

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.

ParameterValue
resolutionBilling period unit (hour, day, week, month, quarter, year)
startStart time/date for usage report
stopStop time/date for usage report
databaseDatabase for which to generate report
tagTags for which to generate report
formatFormat of report (CSV, XML)
filenameFile 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:

https://<computer-name>:<https-port>/dbcloud/op/usage?<report-parameters>

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.

No comments