Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Database Performance Analyzer (DPA) > 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