Dear All,
Since 2 days DNQueue is very slow to proceed DBQueue jobs and when I checked slots, only one slot is using. When I restart DB server it is same.
Is there a chance to force use all slots ? Or change priority?
IAM version: 8.1.4
keepalive param: 120
CPU Core 16
Slots 23 (asinged automatically)
Please have a look the picture and you can see how DBQueue is full and slots from SQL. https://postimg.cc/tsFkdnGW
Thank you in advance
Samet
I mean the setting of the staging level at the main database in Designer. Is it set to production?
In addition check that the value of the CountSlotsMax configuration parameter is not set to 1
HtH
Hi Markus,
Yes all are correct as you said. DB is PROD and config please see the picture.
DB Queue is full and "SAP user account membership in SAP Roles" running very slow. 4162 to process, 35 processing. Since 2-3 hours no changes. With restart getting 10-20 less but it has to be faster.
Regards
Hi Markus,
Yes all are correct as you said. DB is PROD and config please see the picture.
DB Queue is full and "SAP user account membership in SAP Roles" running very slow. 4162 to process, 35 processing. Since 2-3 hours no changes. With restart getting 10-20 less but it has to be faster.
Regards
Thank you Markus.
Is there any way to start DBQueue waiting process manually? Like there are many slots empty, no chance to force?
Regards
