Accessing SAP Java NetWeaver Database Details via JMX MBeans

[#1]

Hi everyone,
We are currently working on retrieving performance metrics from SAP Java NetWeaver using JMX MBeans.  Along with the usual performance data, we also need to gather details about the connected database specifically, information like the database instance ID and related metadata. 
Could you please guide us on which MBeans expose these database details, or if there's an alternative way to obtain this information?Any help or pointers would be greatly appreciated. Thanks in advance!

[redekcs]

Hello @hari0011 

You're on the right track using JMX MBeans to collect performance data from SAP NetWeaver Java. For database-related information, here are a few pointers:
1. Use the SAP-Specific MBeans via Visual Admin or JConsole

SAP NetWeaver Java provides a number of useful MBeans under:

com.sap.*

You’ll want to check:
MBean: com.sap.sql.monitoring:type=SQLDataSource

This MBean exposes high-level metadata about each configured data source, including:

JDBC URL

Active connections

Max connections

Pool usage

You can find this under:

com.sap.sql.monitoring -> SQLDataSource -> Attributes

Check the DataSourceName, URL, ConnectionCount, etc.

Note: You likely won’t see DB instance ID directly here — but you’ll get DB type, host, port from the JDBC URL.

2. Use com.sap.engine MBeans

These include internal monitoring for the Java engine and often expose runtime and resource usage data. Look under:

com.sap.engine -> system -> monitor

Though not DB-specific, some metrics link to database I/O or response times depending on the configured backend.
3. Alternative: Use NWA Diagnostic Tools

In addition to JMX, SAP recommends using NetWeaver Administrator (NWA) for full database identification and analysis:

NWA → Troubleshooting → Java System Reports

Look under Database tab

You’ll find:

Database product name/version

Host

Schema

Connected user

DB Instance ID (if supported)

Best regards,
Chuma

GenAI Assisted Content
SAP Documentation and Tooling References

SAP Help – Monitoring with JMX

JMX Monitoring in SAP Commerce-SAP Help 

SAP NetWeaver Administrator Tool (NWA)

With kind regards

Chuma

[hari0011]

Hi @redekcs
I cross-checked the Mbeans list, not able to find any of the mbean mentioned like 'com.sap.sql.monitoring:type=SQLDataSource'. Im using NW 7.5. Is there any other options we need to enable to get the details of DB connected in the NW system. Im able to get the details through NetWeaver Administrator (NWA), but need to get through mbeans.

Thanks
Harikrishnan