Submit a ticketCall us
Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > No CPU Utilization graph for Sybase 15.7+

No CPU Utilization graph for Sybase 15.7+

Updated January 24th, 2017

Overview

This article addresses the issue where there is no CPU Utilization graph for Sybase 15.7.

Environment

  • DPA 10.0.352 and later
  • Sybase 15.7 and later

Cause 

Sybase changed the way they compute CPU utilization in their MDA tables in version 15.7, which made our CPU utilization appear to be incorrect. So it was set to not display for those versions. There is a default metrics XML file located in the following path. 

{DPA home}/iwc/tomcat/webapps/iwc/WEB-INF/classes/resources/metrics/default-metrics-queries.xml 

If you check the file here you will find the following XML. 

 <metricsQuery className="com.confio.idc.database.metrics.domain.queries.KeyedDeltaCalculationMetricsQuery">
    <sql>
    <![CDATA[
select DISTINCT EngineNumber, IdleCPUTime, CPUTime from monEngine
        ]]></sql>
        <sumMultipleRows>true</sumMultipleRows>
    <frequency>60</frequency>
    <queryTimeout>20</queryTimeout>
    <metricsList>
     <metric name="CPU Utilization By Database">
    <expression>ONE_HUNDRED.subtract(args[0].multiply(ONE_HUNDRED).divide(args[1], BigDecimal.ROUND_HALF_DOWN))</expression>
     </metric>
    </metricsList>
    <supportedDatabaseList>
      <supportedDatabase>
        <databaseType>Sybase</databaseType>
        <maximumVersion>15.6.9999</maximumVersion>

Resolution

 

Perform the following workaround:

  1. Go to Options > Custom Metrics.
  2. Create New > Sybase.
  3. Configure the metric:
    • Database version: All versions
    • Display name: <name of your choice>
    • Category: CPU
    • Use the chart as a percent.
    • SQL script:
      select avg((UserCPUTime)*100/CPUTime) from monEngine where Status='online'

 

 

Last modified

Tags

Classifications

Public