SQLTeam.com | Weblogs | Forums

SQL Server Performance issue (MEMOBJ_RESOURCEXACT)

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

Result:

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?.

4GB is not much RAM for SQL Server. I know that may not be the core issue, but RAM is the easiest and overall cheapest way to improve SQL performance.

The CHECKDB will create snapshots which can also cause performance issues. Nowadays not sure you even need daily checks, but, even if you do, if possible try to do them on a different server if at all possible.