How do you use cloud databases? Take the survey.

Top query search data & Data Retention

DonFergusonDonFerguson Posts: 185 Silver 5
edited September 26, 2023 6:46PM in SQL Monitor
Would somebody please explain how automatic data pruning is supposed to work with with "Top query search data"  stored in the configured ...\SearchEngine\SqlQueries folder of the base monitor?

I ask because when I look in my data retention settings configuration, it shows a grayed out "Retain for" value of "1 week", meaning I can't configure it.  However it shows the "Size on disk" as being 381.83 GB.   

When I total up the index files stored in the SqlQueries folder, the vast majority of the index files are well over 1 week old, leaving me to believe that no actual pruning of that folder is occurring.

So my question is, if no actual pruning is by SQL Monitor is taking place of that folder, would it be safe for me to purge files older than 1 week on my own without breaking the "Top queries search" functionality? 


Sign In or Register to comment.