opc.three
What does this return on your instance:
-- top 10 consumers of memory
SELECT TOP 10
type,
CAST(SUM(single_pages_kb) / 1024.0 AS DECIMAL(10, 2)) AS [SPA Mem, Mb]
FROM sys.dm_os_memory_clerks
GROUP BY type
ORDER BY SUM(single_pages_kb) DESC ;
Thanks... this is the result...
CACHESTORE_SQLCP1049.37
CACHESTORE_PHDR30.23
CACHESTORE_OBJCP20.23
MEMORYCLERK_SQLGENERAL14.54
MEMORYCLERK_SOSNODE8.77
USERSTORE_SCHEMAMGR5.14
OBJECTSTORE_LOCK_MANAGER3.54
MEMORYCLERK_SQLSTORENG2.97
OBJECTSTORE_SNI_PACKET2.54
USERSTORE_DBMETADATA2.32