Skip to Content

Aggregation of Database Analyzer Performance Data

Our SAP Systems are on Unix platforms. I would like to automatically retrieve and distribute some of the aggregated Database Analyzer performance data from liveCache, so the Capacity and Performance owners can have the data readily at hand. Question: is the aggregated data stored somewhere in the /sapdb directory structure on Unix, or is it always calculated on the fly?

Thanks very much.

Gordon

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 06, 2010 at 07:27 AM

    Check the [Database Analyzer Documentation|http://maxdb.sap.com/doc/7_6/2b/361e3bd129be04e10000000a114084/frameset.htm]. Under Features there is a link to the log file information. Not sure whether it's changed over the various releases.

    Nelis

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2010 at 07:34 AM

    removed double post

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2010 at 03:07 PM

    Upon further investigation, starting with Nelis's reference, I found that the aggregated Database Analyzer data is in the SDBCCMS table of the monitoring system. Is there a report or function that can be used to extract this data? I'm thinking of something similar to SWNC_COLLECTOR_GET_AGGREGATES for querying the SWNCMONI table to get ST03 data.

    Thanks very much.

    Gordon

    Edited by: Schlegel Gordon on Apr 7, 2010 11:08 AM

    Add comment
    10|10000 characters needed characters exceeded