The SQL Server Default Trace will not enable when there is lack of space in the disc where the trace file is located. By default this is on the C: driver of the monitored host.
In this scenario, a message similar to the following should be written to the SQL Server error log
Trace ID '#' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the problem.
- The available space on the disks can be viewed if an Infrastructure agent is monitoring the host.
- Navigate to the Global View databases dashboard
- Select a SQL Server agent and drill down into the Activity | Realtime page
- Click the Disk Utilization component under Disk Activity in the bottom right corner of the page
- In the popup, click the Investigate using the Operating System drilldown link
- The disks should be visible on the bottom right side of the page with a space limited disk appearing in red.
.png)
Since the Error Log panel does filter by default on Severity 16 issues like this, an error log filter could be added for text like "was stopped because of an error" or "0x80070070" to include errors like this in the future in the Error Log panel and alarms. Knowledgebase article
4308264 details how to add new Error Log filters to a SQL Server agent.
Enhancement Request FGSS-I-161 has been logged to add a SQL Server Error Log filter in the future to include this scenario to the SQL Server cartridge. This will be considered by Product Management for a future release for the SQL Server cartridge.
.png)
.png)
