on 01-13-2016 9:55 PM
Hi.
We have an application written i PowerBuilder 12.5, which has a lot of code for doing calculation in the database.
As of lately, one of our customers has noticed that when this particular code is running, dbsrv12.exe is using 90-95% CPU-power on all cores as the same time.
However, when we run the same code against another database (same schema and EBF), dbsrv12.exe is using only 20-25% on 1-2 cores while the other cores is idle.
Is it possible to trace the queries and activity in the database to se if any indexes or something else is wrong?
I have also done the exact same on my laptop running dbeng12.exe, and the same thing is happening.
On one database all 8 cores is experiencing 90-95% load while on the other database is utilizing only 2-3 cores at 20% while the rest is idle.
So I can trace both database and source code if needed.
Regards,
Bjarne
http://dcx.sap.com/index.html#1201/en/dbusage/ug-perform.html
There are several tools you can use (link above for more details).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bjarne,
I was wondering if you could refer the following tutorial to find out slow SQL statements, and check the query plans.
http://dcx.sap.com/index.html#1200/en/dbusage/ug-appprofiling-s-5646504.html
Best regards
Zhang Yun-zheng
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bjarne,
did you check / adjust the max_query_tasks option? I found it responsible for occasional erratic behavior with queries executed in parallel. If you set the option to 1 and still observe the same behavior, the reason is s.th. different.
HTH
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bjarne,
Do you apply EBF of SQL Anywhere version 12?
The EBF fixes many performance issue. Latest EBF is EBF4344 released on December 23, 2015.
Thanks,
Atsushi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.