LOTS of queries on SITE_SUPPORTING_CERTIFICATES

Before submitting a ticket to IBM Support, I thought I would ask here first. Using our SQL monitoring software we’ve found that there is one query that is happening quite a bit on our system that is causing a lot of wait times around the network:

SELECT SiteType, SiteTag, S.SHA1Hash, Certificate FROM SITE_SUPPORTING_CERTIFICATES S INNER JOIN CERTIFICATES C ON S.SHA1Hash = C.SHA1Hash WHERE S.IsDeleted = 0

Each query processes about 700 rows, but in the first 11 hours today it executed almost 16000 times. This query is happening with the BESRootServer and GatherDB.

Is this normal behavior or is there a setting that we have turned on or off that is causing this query to happen so many times?

1 Like

Whatever happened to this?

@jgo I didn’t get any additional comments here and I decided not to try to pursue it via a support channel. Hopefully this is just normal behavior of BigFix. For now I didn’t want to commit the time to get an answer from IBM support.