Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

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