Litespeed related issues in Spotlight on SQL Server Enterprise version 10.0.1 (4339655)

When accessing the Database Drilldown page and selecting a DatabaseName from the top section, and then selecting the LiteSpeed Backups tab in the Database Details tab on the lower half of the page. A caution icon shows with the message "Litespeed activity has exceeded limit of 10000..."

In addition to this, Spotlight's query might be blocking LiteSpeed backups. Spotlight alerts that LiteSpeed Backups Failed, and LiteSpeed Backup Warnings seems to be blocking LiteSpeed backups.

Issues that may be related after upgrading to verion 10.0.1 have resulted in:

Error:  ..OOPCollector request failed: Read timed out. 

Both repositories may quickly grow larger after upgrading to version 10.0.1 (Spotlight Statistics Repository and Playback Database)

Diagnostic Server may randomly fail with error in the Application Event viewer: "Stopping Diagnostic Server. Out of memory GC overhead limit"

Replace QS_Litespeed.sql to {DS install dir}\conf\package\sqlserver_spotlight\2000.

and replace QS_Files.sql to {DS install dir}\conf\package\sqlserver_spotlight\2005.

There is no need to stop the Diagnostic Server to replace the script file. It will start using the updated SQL as soon as it has been replaced. The script reduces the number of rows collected, which eliminates the exceeded limit error, and also does not lock the rows it reads, which will stop the issue where backups are failing.