Home Forums SQL Server 2008 SQL Server 2008 Administration can I measure how much memory is allocated to the buffer in SS2K8 on VMWare accurately RE: can I measure how much memory is allocated to the buffer in SS2K8 on VMWare accurately

  • September 21, 2012 at 3:06 am

    #1540534

    If you want to measure memory usage of Buffer pool,

    Select Count(*) * 8 / (1024.00) 'BufferPoolSize In MB' From sys.dm_os_buffer_descriptors