Home Forums SQL Server 2005 Administering 4 database instances in a single server (SQL Server 2005) RE: 4 database instances in a single server (SQL Server 2005)

  • Here is a quick query to see the internal "point in time" memory clerk use for the sql instance

    SELECT @@servername AS InstanceName,SUM(single_pages_kb)/1024 AS [SPA Mem, Mb]

    FROM sys.dm_os_memory_clerks

    ORDER BY [SPA Mem, Mb] DESC

    You would need to run this against each instance and run it multiple times to see how things are changing or not changing.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events