ApexSQL Audit Processor Distributed process high ram usage (4373694)

ApexSQL Audit Processor Distributed process high ram usage

ApexSQL Audit Processor Distributed process high ram usage on the machine running the affected SQL Server
 

WORKAROUND
The following is the text file of the restart DistributedProcess powershell script:

# Variable for storing the the log file path for ApexSQL Audit process restarts
$filePath = "C:\Users\central\Desktop\TestPath\restartingDistributedProcess.txt"

#Check if the process named "ApexSQL.Audit.Processor.Distributed" is running and restart it (end it)
if (Get-Process -Name ApexSQL.Audit.Processor.Distributed -ErrorAction SilentlyContinue) 
{
    taskkill /IM ApexSQL.Audit.Processor.Distributed.exe /F

    # Write/append output to the textual log file every time the process is successfully restarted
    "[$(Get-Date)] ApexSQL.Audit.Processor.Distributed process(es) successfully restarted." | Out-file $filePath -Width 200  -Append

} 
else 
{
     # Write/append output to the textual log file every time the process is not successfully restarted
    "[$(Get-Date)] ApexSQL.Audit.Processor.Distributed is not running or the process(es) can not be accessed." | Out-file -Width 200 $filePath -Append
}

Simply schedule the above script in the task scheduler with the admin rights on the machine running the affected SQL Server

STATUS
Waiting for fix in future release of ApexSQL Audit

DEFECT ID
204956