Top Query Search can now be configured to store its index files in a location other than the default of %ProgramData%\Red Gate\SQL Monitor\SearchEngine

Step-by-step guide

1. Create the new folder you would like to use.

2. Ensure that you have granted access to the folder you would like to use to the service account running the base monitor service.

   Additional note for high availability

   In the case of a high availability install of the SQL Monitor base monitor service, we would advise using a file share that can be seen from both active and passive nodes for this.

3. Open the folder %ProgramData%\Red Gate\SQL Monitor\SearchEngine on the system running the base monitor.
4. Stop your base monitor service.
5. Move the contents of %ProgramData%\Red Gate\SQL Monitor\SearchEngine to your new folder.

6. Run the below query on your SQL Monitor repository database, replacing <Your new path here> with the new folder you created above.

   INSERT INTO settings.KeyValuePairs
   (KeyName, KeyValue, KeyValueType)
   VALUES
   (   N'SearchIndexPath',
       N'<Your new path here>',
       N'STRING'
   )

7. Start your base monitor service again.