Sql-server – SQL log directory has too much dump file

dumpsql server 2014sql-server-2008

My SQL Server 2014 is automatically creating SQL dump file. It is generating automatically to take all the spaces and hangs over the database.

Error: 8310, Severity: 16, State: 1.
Cannot create (or open) named file mapping object 'Global\SQL_110_MEMOBJ_24_SQL14_0'. SQL Server performance counters are disabled.
Error: 3409, Severity: 16, State: 1.
Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.
Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)

Error Log
Location

Best Answer

With Reference sql server 2008 automatically generate stack dump

Set 'msdb' to single user mode and run the following command

DBCC CHECKDB('msdb', REPAIR_REBUILD)

Reset 'msdb' to multiuser mode the same process for your error database. This resolved our problem.

Related Question