Version 1


    This custom metric will collect the percentage of CPU work the Adaptive Server spent since the last time Adaptive Server was started. 



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