Forum Discussion

AKL's avatar
AKL
Level 6
11 years ago

Discovery Accelarator SQL CACHE Files

Hello All

I am feeling like a Discovery accelarator noob and unable to figure out cause of existence of certain files.

We've Discovery Accelarator 11 CHF2 environment along with Enterprise vault 11 CHF2. On backend or SQL (2008 R2 SP1) server for Discovery accelarator, we've a folder named Data Collection Cache and it has couple of huge files with extension *.CACHE and name DASQL_MSSQL10_50.MSSQLSERVER_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_4

I am not really sure what these files are and where they're generating from. I would like to change their locations if possible as drive they're existing on is getting filled up really fast due to increasing size of these CACHE file.

I can confirm they're not item pre-fetch cache folder/files, that folder is pointing to a different location on DA box itself.

Hope its an easy answer. !

Thanks in advance !

  • Hello, AKL;

    I believe your SQL DBA has enabled the Cache feature in SQL Server whereby it caches certain data in order to make the server operate faster.  Please ask them to check to see if this feature as, indeed, been enabled as it could be using the *.CACHE files and take up a lot of drive space.

    DA does not use *.CACHEf files.  It will, however, use *.NDF files for any case or research folder that becomes Analytics enabled.

    Kind regards,

    Ken

  • Hello, AKL;

    I believe your SQL DBA has enabled the Cache feature in SQL Server whereby it caches certain data in order to make the server operate faster.  Please ask them to check to see if this feature as, indeed, been enabled as it could be using the *.CACHE files and take up a lot of drive space.

    DA does not use *.CACHEf files.  It will, however, use *.NDF files for any case or research folder that becomes Analytics enabled.

    Kind regards,

    Ken