If Service Desk Manager is completely down, or seeing severe performance issues the following logs may indicate an issue with the MDB:
05/08 10:01:43.86 SERVER sqlagt:select17 9276 SIGNIFICANT prov_base.c 1010 SQL Query has returned (20000) rows for (USER). Clause (SELECT <SQL Statement>) Input (<None>)
05/08 11:01:19.26 SERVER web:primary:2 11764 SIGNIFICANT session.c 4091 This request took 144349 milliseconds to complete. session id:636432343 login name: htmpl name:login.htmpl
These logs may be Frequent with high milliseconds to complete and/or high numbers of SQL Query results.
This log may be seen also:
05/08 10:49:32.28 SERVER boplgin 10444 SIGNIFICANT bplhndlr.c 1719 BOPLGIN not ready (status=6143); request queued
Release : 17.3
MDB has become backed up with SQL Queries
Restarting the SQL server should clear the queued queries and SDM should be functional.
Suggest the customer examine these queries and their purpose.
SDM is not meant to handle a high amount of queries and results.
Broadcom offers Jaspersoft Reports to handle reporting functionality if the queries are used for reporting purposes.