Hi team, we have recently upgraded Solarwinds environment to NPM 12.4 version (Orion 2018.4) along with other modules - VNQM, IPAM, NCM.
Since we have upgraded we have started facing issues with the Database, as the transaction logs are reaching more than 1 TB in size and blocking the further operations, even not able to login to Solarwinds Console, DB team has done all the options they had but it transaction log is unstoppable.
Now DB has found one command which is causing blocks and not letting further operations, they suspect that this might be the root cause for this issue. Could you please check and let us know whether this is potential cause for this issue or something else and what can be done in order to resolve this issue.
We had initially Full recovery model now we have changed it to Simple but still same issue with Simple recovery model.
The same delete operation has been running from two different host CHIRDCSWPE-01 and CHIRDCSWPE-05 which has been creating blocking.
329 Poller-01 2019-03-21 21:01:48.873
DELETE Wireless_Clients WHERE NodeID = @NodeID AND LastUpdate < @PollTi
430 Poller-05 2019-03-21 21:01:25.440
DELETE Wireless_Clients WHERE NodeID = @NodeID AND LastUpdate < @PollTi