Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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