Using MDA Tables in SAP ASE

    By: Malathy Mani on May 01, 2014

    MDA Tables were introduced in ASE – But why are they still not popular?

    In this article, we'll explore MDA Tables and see how they can be used as valuable tool for better troubleshooting.

    MDA tables provide a richer, more powerful monitoring interface and a complement to the sp_sysmon report. Yet, there are fewer people who have used them because of the lack of knowledge and understanding of these tables. Let us explore these MDA tables and see a few examples of how MDA tables can help in better troubleshooting.

    If replication server is added to the mix, MDA can also be used to troubleshoot slow replication server performance at the replicate. MDA tables can be used to gather information on the maintenance user (thread) to evaluate SQL. There are some MDA table limitations: repAgent statistics can only analyzed by sp_sysmon for “repagent” performance, spinlock contention is not fully captured in MDA and requires sp_sysmon output for that and also for metadata cache sizes.

    What is MDA?
    MDA can mean “Monitoring Data Access” (or “Monitoring and Diagnostics for ASE” or “Monitoring and Diagnostic Access or “Monitoring and Diagnostic API”).

    MDA tables help overcome some limitations as the amount of data stored or trending over time is only limited by disk space and database size.

    There are about 41 proxy tables in the master database. All these tables are named mon%'
    (i.e.'monObjectActivity'). These tables can be queried with regular SQL – the do's and don'ts will be provided later in this article. These proxy tables are mapped to native RPCs.

    MDA tables can be queried to report information about the activity of server processes and applications, query performance, usage of database tables,    efficiency    of    data    caches, I/O activity on database devices, and other diagnostic data about SAP ASE that affect system performance.


    Login to read the article. Not a member? Create a free account!




    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk