SOLVED How to enable Back-End Systems WebLogic JDBC monitoring by WLSDM?
-
I am working on configuring WLSDM as POC in my company. If all goes fine, planning to buy the licence. As of now i am running WLSDM with trial licence. One of the main reason to use WLSDM is to find the SQL which are running for long time. But after configuring the WLSDM, i am unable to view any backend systems. Please help me to resolve this so that i can complete the POC and go ahead with purchase. I am attaching the screenshot.
-
@sravanreddyg said:
I am working on configuring WLSDM as POC in my company. If all goes fine, planning to buy the licence. As of now i am running WLSDM with trial licence. One of the main reason to use WLSDM is to find the SQL which are running for long time. But after configuring the WLSDM, i am unable to view any backend systems. Please help me to resolve this so that i can complete the POC and go ahead with purchase. I am attaching the screenshot.
Hi sravanreddyg,
It’s for sure it’s working but you need to setup back-end configuration
This screen capture shows that you have not configured your back-end conf properly. Here is the steps for the rest.
-
Install wlsdm_agent.jar to your relevent WebLogic managed servers. (Watch this video for your reference: https://youtu.be/a998IUcq4NY?t=2m25s)
-
On this page “Configuration > Montiroring & Diagnostics” select “New Back-end Monitoring” on page operations menu which is located on top right of every page.
-
Then choose relevant WebLogic managed server from combox and select “JDBC Execute Satetements” and click save at the end. Do not forget to activate alarm and threshold configuration for your long running JDBC events.
-
That’s all. Go to “Monitoring & Diagnostics > Back-end Systems > JDBC” page. Then you must see your live SQLs.
By the way, which WebLogic and Java version are you working on?
Note: Firstly we have full featured free edition for development mode domains.
-
-
@sravanreddyg said:
I am working on configuring WLSDM as POC in my company. If all goes fine, planning to buy the licence. As of now i am running WLSDM with trial licence. One of the main reason to use WLSDM is to find the SQL which are running for long time. But after configuring the WLSDM, i am unable to view any backend systems. Please help me to resolve this so that i can complete the POC and go ahead with purchase. I am attaching the screenshot.
Hi sravanreddyg,
It’s for sure it’s working but you need to setup back-end configuration
This screen capture shows that you have not configured your back-end conf properly. Here is the steps for the rest.
-
Install wlsdm_agent.jar to your relevent WebLogic managed servers. (Watch this video for your reference: https://youtu.be/a998IUcq4NY?t=2m25s)
-
On this page “Configuration > Montiroring & Diagnostics” select “New Back-end Monitoring” on page operations menu which is located on top right of every page.
-
Then choose relevant WebLogic managed server from combox and select “JDBC Execute Satetements” and click save at the end. Do not forget to activate alarm and threshold configuration for your long running JDBC events.
-
That’s all. Go to “Monitoring & Diagnostics > Back-end Systems > JDBC” page. Then you must see your live SQLs.
By the way, which WebLogic and Java version are you working on?
Note: Firstly we have full featured free edition for development mode domains.
-
-
@wlsdmadmin said:
Note: Firstly we have full featured free edition for development mode domains.
Great, It worked… I am using 10.3.6 with JDK 1.7, Only thing i see the problem is its clearing out old data. Is there any way i can get list of SQLs ran for this amount of time? I see the reports section but i dont see SQL execution time included there.
-
Hi,
You can enable store data feature on the configuration page. Give a threshold for the JDBC store records. This means; SQLs over threshold will be saved to reporter. Just select statement and get report. On caharts you’ll able to see WebLogic JDBC durations. Otherwise you can get reports from daily reports. Select all and get reports.
In the next release we’ll have top JDBC events for WebLogic.
Have you setup JDBC email alarm settings? You can also see long running SQLs on Backend Notifications page. -
@wlsdmadmin I am unable to find this options. DO you have any supporting documentation for configuring these kind of reports and enabling thresholds.
-
@sravanreddyg It’s standard feature of WLSDM. You should configure these settings while completing wizard. But it’s not problem. You still can update on Back-end tab on configuration pages. Just click on edit button for the JDBC entry; enable threshold and “store data”. That’s all. You can follow metric threshold documentation as a reference. Here is the doc URL: http://www.wlsdm.com/docs/help/#3.CompletingWLSDMWizard
