SQLa0000.tmp file rapidly increases
We have noticed recently that there is a temp file in C:\windows\temp called sqla0000.tmp (c:\windows\temp\sqla0000.tmp) that continuously grows over time until it completely fills the hard drive. This has happened 4 times in the last 5 months. It seems that the file grows gradually and then on one day it balloons to fill the entire hard drive.
This file is associated with Symantec Endpoint Manager as you need to stop the SEPM service to delete it.
I have tried searching for other people with the same issue and am unable to find anything online or in this support forum.
Below is a graph showing the total hard drive usage over the last year. As you can see in the graph, there are four times that the spikes appear in the last 5 months all pertaining to the sqla0000.tmp file.
How do I control the file sqla0000.tmp to stop it from expanding limitlessly? Having to stop and start the service manually is not ideal and would much rather this be automated. I have looked into the database server section of SEPM under Admin > Servers > Localhost and cannot see anything other than Truncate Transaction Log and Rebuild Indexes, both of which are scheduled to happen daily. It seems that it is over a day or two that the hard drive fills up and I am struggling to find out why.
Any assistance would be gratefully received.