Running multiple ApexSQL Audit schedules at the same time crashed audited SQL Server instance
After removing the report which generates all logs from several ApexSQL Audit schedules all of those schedules ran at the same time causing SQL Server to crash
When schedules ran 10 min apart no crash either.
Once all necessary, ApexSQL Audit log files, SQL Server log files and Windows Event Viewer files, are thoroughly investigated the most probable cause for this crash is explained below:
"By examining Windows Event Viewer files, based on the exported CSV it appears that the issue is caused by a memory limitation.
There are multiple SQL Server insufficient memory errors logged:
"There is insufficient system memory in resource pool 'internal' to run this query.
The Windows Error Reporting Service terminated with the following error:
The paging file is too small for this operation to complete."
The above leads us to the conclusion that ApexSQL Audit is not to be blamed for SQL Server crash but the low/insufficient system memory resources on the machine running the mentioned SQL Server.
Via ApexSQL Audit you did have initiated that troublesome report that generates all events from several schedules, and once all those queries required output from SQL Server at the same time, the SQL Server kicked in demanding a lot more RAM for calculations/pulling large portion of data at once.
Once there was not enough ram left SQL Server sadly crashed.
One more thing that backs up this conclusion is that once those schedules are set to run 10 min apart SQL Server stopped crashing which can be seen in the shared files
