Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Database Performance Analyzer (DPA) > No CPU Utilization graph for Sybase 15.7+

No CPU Utilization graph for Sybase 15.7+

Updated November 12, 2015

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
11:39, 24 Jan 2017

Tags

Classifications

Public