Skip to Content

Which way to steer your ship?

Have you ever taken database performance metrics, downloaded them to Excel, and created charts and graphs so that trends became more clear?

Of course we all know management likes pictures to convey information, but it helps us techies as well to be able to visualize how performance is trending over time. Sometimes we get so caught up in the daily operation of our systems that, even if you’re watching the system daily, small increases over time can add up and become issues before you know it.

Not to mention, sometimes it isn’t until you look at data on a graph that patterns become visible.

(I’m not being specific about *which* data to look for, because every system and database platform is unique, and you really need to understand yours and how they’re used to determine which data are the most important to keep an eye on.)

 

The treasure you can find

SAP have developed Solution Manager with the capability of storing data in BI cubes, and this is the perfect place to report on the performance of systems in your landscape. And with the Database Performance Warehouse, part of the DBA Cockpit, you can get detailed data and charts to support reporting on the database performance metrics that are important to you.

Enabling this functionality is simple, and I’ll show you how to do this now.

 

The map to guide you

First step is to log in to Solution Manager, and go to transaction ‘solman_setup.’ From there, click on Managed System Configuration > Configure Technical System.

Managed System Configuration

 

 

Select a database from the drop-down menu, and validate the populated information, or change:

Wizard Input Screen 1

 

Enter any information requested, then click Next:

Wizard Input Screen 2

 

The configuration should now be deployed automatically, including the structures in the target database, and the collectors to retrieve the data and populate the BI cubes in the Solution Manager system. If all goes well, you should see the following screen, as I did:

Wizard Input Screen 3

 

The next step is to let the collectors collect some data so that you can display it. Once that happens, we’ll open up the DBA Cockpit again with transaction ‘dbacockpit.’ Select the database you’ve just deployed the configuration to, make sure you get connected, then navigate to Performance > Performance Warehouse > Reporting.

DBA Cockpit Navigation Screen 

 

In my system with NetWeaver 7.0 Enhancement Package 2, I get the following screen (NW 7.0 EhP1 will open a new browser window, but EhP2 opens in the sapgui for me):

Buffer Pool Quality

 

So from here on out, all of the graphs are based on embedded BI queries that may or may not exist for you, depending on your database platform. The good news is, if you don’t see the charts you want to see, you can create your own simply by using the standard BI query development tools to create a new query, or by modifying an existing query.

Here’s one for Database I/O read and write times:

DB I/O Read and Write times

 

And of course, as these are embedded BEx queries, all of the standard filter and drill-down capabilities exist by right-clicking on the data:

Context Menu

 

Query Properties:

Query Properties

 

We have reached our destination, but this is only the beginning of the journey

So that’s basically it. For those on an Oracle platform, these charts may be very similar to what Oracle Enterprise Manager offers, though OEM did not, last I worked with it, offer any sort of analytical capabilities on that data. I am on the DB2 platform now though, and IBM does not offer any free server-based tools like OEM that are always watching your databases and monitoring performance. I do not know what SQL Server or MaxDB have to offer, so I cannot comment there.

The good thing about Solution Manager’s database performance warehouse is, if you support multiple database platforms, whether as a consultant for various clients, or whether you have multiple platforms in your customer environment, this allows some standardization across those platforms for database performance reporting.

So that’s it, I hope this helps, and please comment below if you have experiences with database performance warehouse to share, or questions you need answers to.

 

Reference:

Database Performance Warehouse Webinar presented by SAP Labs

To report this post you need to login first.

15 Comments

You must be Logged on to comment or reply to a post.

  1. Tom Cenens
    Hello David

    Looks nice, I haven’t worked much on other databases besides Oracle.

    SAP was going to integrate a database part into Root Cause Analysis in Solution Manager 7.1. When I had access to the Solution Manager 7.1 beta it was missing so I don’t know if it’s there yet.

    Solution Manager 7.1 installation is pending so once I get access I’ll take a look.

    Kind regards

    Tom

    (0) 
    1. Community User Post author
      Thanks, Tom. Of course, this doesn’t require Solution Manager 7.1 – my system is currently 7.0 EhP1. So if you’ve got time to kill prior to your 7.1 upgrade, you can pass your time enabling the database performance warehouse. 🙂

      Cheers,
      David.

      (0) 
      1. Tom Cenens
        Hello David

        We don’t have DB2 running, this is only for DB2 right?

        We have our Oracle databases configured in DBA Cockpit. There are other reports available for Oracle like AWR report etc.

        Kind regards

        Tom

        (0) 
        1. Community User Post author
          Tom, no, it’s for all database platforms. I’ll have to find it, but there is a deck from SAP that shows how many standard reports are available in the performance warehouse for each database platform. Oracle was the only one at zero, but that number was to increase with Solution Manager 7.1. I was told by someone at SAP that you could enable it for Oracle, but there simply were no standard reports, but perhaps that is not the case.

          I will find that deck and link it here.

          Cheers,
          David.

          (0) 
          1. Steffen Siegmund
            Hi Tom,

            yes, the Oracle DPW content is shipped with SAP Solution Manager 7.1 SP3. It is available in the SAP Solution Manager (Tx SOLMAN_WORKCENTER) under Root Cause Analysis -> Database Analysis.

            Best regards,
            Steffen

            (0) 
        2. Community User Post author
          Tom, here is the deck to which I was referring, from 2009:
          http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/9075f129-12b4-2c10-20a4-9b60b5a60efa

          It shows the number of standard reports available for each database platform delivered for NetWeaver 7.0 EhP1 and EhP2:
          Database EhP1 EhP2
          DB2 LUW  39    39
          SQL Server 9    11
          MaxDB      1     9
          Oracle       0     8

          So if you’re on Oracle now, on NetWeaver 7.0 EhP2, you should, if this deck was correct, have access to 8 standard reports, and be able to build your own custom reports as you wish.

          Cheers,
          David.

          (0) 
            1. Community User Post author
              Tom, I have emailed the author of this deck to see if Oracle reports were delivered as predicted. I will let you know what he says.

              Cheers,
              David.

              (0) 
  2. Ranjith Jacob
    Hello David

    My solman system is SAP EHP 1 for SAP Solution Manager 7.0. I couldn’t find the Performance Warehouse in DBACOCKpit as you have shown in the blog. IS there any configuration required. I have integrated systems into DBACOCKPIT.
    Reply to ranjith.jacob@scotts.com

    Thanks,
    Ranjith

    (0) 
    1. Community User Post author
      Hi, my Solution Manager system is also 7.0 EhP1. I got the 7.0 EhP2 screenshots by going to one of the managed systems directly which is running NetWeaver 7.0 EhP2.

      I’m not sure why you’re not seeing it. Are you in expert mode in the DBA Cockpit?

      Regards,
      David.

      (0) 
      1. Ranjith Jacob
        Hi David

        I am getting the below error while DBACOCKPIT configuration. 

        DB connection Id :%_DEV_R3DZ.CC.US.SCOTTSCO.COM_

        Connectivity test :
        Database history :Not supported for this DB platform
        Extractors activation :The DB performance warehouse is not available, thus the DB extractors were not activated

        Is this report not available for Oracle ?

        Thanks,
        Ranjith

        (0) 

Leave a Reply