Description
This custom metric will collect the percentage of CPU work the Adaptive Server spent since the last time Adaptive Server was started.
Metric Definition
To create the custom metric, click on Options > Custom Resource Metrics and configure the metric similar to this:
- Database Type: Sybase
- Database Versions: <no limitations>
- Display Name: CPU Busy
- Description: <add your own description>
- Category: <add to whatever category you like or create a new one>
- Units: Check the "Chart as a Percent (0-100)" box
- Metric Type: Single Value
- Frequency: 60
- Timeout: 20
SQL Statement
SELECT convert(DECIMAL(5, 2), (100 * convert(FLOAT, @@cpu_busy) / convert(FLOAT, (@@idle + @@io_busy + @@cpu_busy))))