Home Forums SQL Server 2005 Administering Help!... Memory Use on Windows 2008 R2, SQL Server 2005 x64. The physical is 98% RE: Help!... Memory Use on Windows 2008 R2, SQL Server 2005 x64. The physical is 98%

  • 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 ;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato