SQL log directory has too much dump file 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)
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.