When there is something “unexpected”, SQL Server kills the SPID and generates a dump. Due to this, C drive has filled up and database is about to crash or has stopped processing.
Checklist to free space
1. cycle the SQL errorlog to remove large error log files from the C drive - see script below
2. clear out old mdf and ldf files from the \Data directory
3. clear out old stack dumps and crash dumps from \LOG directory
4. remove any redundant backup files
5. delete old roaming user profiles from C:\documents and settings
6. check any \temp directories and .tmp files for files to delete
7. empty the Recycle Bin
Here is an image with location
Delete the Log Files.
