DX Unified Infrastructure Management

 View Only
Expand all | Collapse all

Name of the table where the sql server performance is stored in the database.

  • 1.  Name of the table where the sql server performance is stored in the database.

    Posted Sep 14, 2021 10:24 AM
    Good morning

    Broadcom Team, I have a need with one of our customers, in previous versions we delivered some reports using the performance designer for what was the SQL database engine.

    Currently using CABI Jaspersoft it has become difficult for us to find a way to make them similar. However I think that if I can know in which table of the UIM data model the UIM data is stored I could design a more or less similar report, what data should I find in the table:

    *IO SQL
    *PERFORMANCE QUERY SQL
    *MEMRORY CACHE
    *TOTAL MEMORY USED
    *TOTAL MEMORY FREE

    ETC...

    . Do any of you know in a referential way in which table those data are stored, could you help me.

    Having the data from the tables I can work with a new domain in cabi and plot what I need to show


  • 2.  RE: Name of the table where the sql server performance is stored in the database.

    Posted Sep 14, 2021 12:25 PM
    You can look up the table(s) name in the table s_qos_data.