SQL Server Performance issue due to high Memory utilization
SQL Version: Microsoft SQL Server 2014 (SP3-GDR) (KB4583463) Standard Edition (64-bit)
Min Memory:0, Max Memory:4096, System Memory:8 GB
SQL server performance is getting slow down day by day on a Dell T320 Server.
We run DBCC CheckDB command as part of daily database backup Job and the DBCC command goes to suspended mode when the system runs for ~14 days continuously.
Other database applications fails to execute after the DBCC command failure
We got the memory utilization by using the queries below
SELECT TOP(5) [type] AS [ClerkType], SUM(pages_kb) / 1024 AS [SizeMb] FROM sys.dm_os_memory_clerks WITH (NOLOCK) GROUP BY [type] ORDER BY SUM(pages_kb) DESC
MEMORYCLERK_SQLSTORENG 2214 MEMORYCLERK_SQLBUFFERPOOL 441 MEMORYCLERK_SOSNODE 52 MEMORYCLERK_SQLCLR 32 USERSTORE_SCHEMAMGR 25
and the highest memory utilized memory object is MEMOBJ_RESOURCEXACT
MB Used type 2212 MEMOBJ_RESOURCEXACT
We want to narrow down to the exact object which is holding this memory. Looks like the memory is not getting released by this memory object.
What is the way to get more details about MEMOBJ_RESOURCEXACT memory object?.