SOLUTION:
In Spotlight, the option "Store SQL text and query plans in playback" can be adjusted globally or per connection; go to Configure | Spotlight | Store SQL text and query plans in playback or right-click a connection | properties | Un-check the box of the same name, respectively.
After making any adjustments in the Spotlight options, it's possible to go further by adjusting the Diagnostic Server configuration file to reduce cache capacity.
1. Go to <DS_Install_Path>\Agent\conf. (i.e. "C:\Program Files\Quest Software\Diagnostic Server\Agent\conf").
2. Locate the file "DiagnosticServer.properties" and copy the file to your Desktop as a backup. (Do save a copy in the original location.)
3. Open the file in a text editor like Notepad.
4. Find and modify the following lines:
- com.quest.adk.sqlTextCacheOnDisk=500 (modify to) com.quest.adk.sqlTextCacheOnDisk=50
- com.quest.adk.sqlTextCacheLifeTime=24 (modify to) com.quest.adk.sqlTextCacheLifeTime=12
5. Save the file. If you get permissions issues; save another copy to the C:\ drive, modify and then paste\replace the file.
6. Stop the Diagnostic Server service.
7. Delete the entire "caches" directory in <DS_Install_Path>\Agent\data\caches.
8. Start the Diagnostic Server service.
NOTE 1: Reducing caches size might result in having the Diagnostic Server work harder (compression) and bother the SQL Server connections as it will ask for the same SQL batches/query plans again and again.
NOTE 2: Just perform steps 6 - 8 if no modifications to configuration files are desired.
