Version 1

    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 whatevfer 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))))