LiteSpeed_GatherJobStatistics is blocking other tasks or running excessively.
LiteSpeed_GatherJobStatistics blocking even though Instance Config has been rerun with the selection NOT to gather DTS & Job Statistics.
(HKEY_LOCAL_MACHINE\SOFTWARE\Imceda\SQLLiteSpeed\Engine\ActivityServers for each instance) has the value "PushJobStatsEnabled" = 0.
No scheduled job to call the SP in agent jobs.
The updates are based on LiteSpeedLocal having any rows with StatusTypeID = 1 and ReplicateID is null and the frequency of updates that were scheduled when Instance Config was run.
As long as the LiteSpeed for SQL Server Update Native Backup statistics job and/or the LiteSpeed Activity Service aren't running, the process won't run and cause the blocking.
WORKAROUND:
To disable the LiteSpeed_GatherJobStatistics, rerun the Instance Configuration and select "Do not gather Native SQL Server backup activity".
This selects whether you want to update the local repository with information about native SQL Server backup activity and view it in the LiteSpeed UI Console. This setting will allow the LiteSpeed backups, restores, maintenance plans, etc. but will not utilize the LiteSpeed Activity Service, to call the LiteSpeed_GatherJobStatistics stored procedure.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center