Using Studio to Create the Database and Tables for Metrics Data Storage

If you need to create the database and table that are used to store your usage metrics without using Studio, you can use the following instructions.

If metrics are enabled, you cannot edit the values on the page. To modify any of the values, make sure to clear the Enable check box.

To use Studio to create the metrics database and required tables

1. In the Studio resource tree, select localhost > policy > metrics.

2. Right click and select Open.

3. Browse to an existing data source that supports the storage of metrics data. See Supported Data Source Types for Metrics Storage.

4. Select a schema location to hold the data.

5. Create or bind to the following tables:

Table Name	Description of Steps to Create the Table
metrics_sessions	• Click Browse. • Navigate to the data source or schema where you want to create the table.
metrics_requests	• Click Browse. • Navigate to the data source or schema where you want to create the table.
metrics_resources_usage	• Click Browse. • Navigate to the data source or schema where you want to create the table.

6. Click Execute DDL.

7. Click OK.

8. Click Save.

9. Optionally, make selections for the following:

Option	Description
Memory Threshold	Number of megabytes to set aside as the buffer space to store records. When the buffer reaches the threshold, the results are posted to the metrics tables.
Request Count Threshold	Number of records or rows to retain in the buffer. When the buffer reaches the threshold, the results are posted to the metrics tables.
How long do you want to keep the metrics data?	Use to indicate the number of days you want your metrics data retained. The default is 30 days.
How often do you want to run the truncate process on expired data?	Use to indicate the time frequency with which you want the metrics collection database data to be truncated. The default is 1 hour.

10. Click Enable.