Post reply

memory management

  • June 26, 2003 at 11:37 am

    #58799

    We're running SQL2k EE and Win2k AS and have AWE enabled with 7GB of RAM allocated to SQL. Is there any way to see how SQL is allocating and using this memory? I thought at one time there was a undocumented procedure that did this.

  • June 26, 2003 at 11:48 am

    #463303

    Use System Monitor (Performance Monitor) to retrieve information on SQL Server memory usage and available memory. Task Manager does not provide accurate memory usage information for AWE. Therefore, the memory quoted for sqlservr.exe is not correct. To obtain the correct amount of SQL Server memory usage, you can use the Total Server Memory (KB) performance counter, activated through System Monitor, or select the memory usage from sysperfinfo.

    select * from sysperfinfo where counter_name like '%Server Memory%'

    Edited by - Allen_Cui on 06/26/2003 11:48:36 AM

  • June 26, 2003 at 11:57 am

    #463308

    Thanks. I was looking for a way to see how much memory was being allocated to the various buffer pools. At one time, there was a stored procedure for this.

  • June 26, 2003 at 12:26 pm

    #463318

    sysperfinfo will give all information you are looking for. Meanwhile, I guess you are looking for dbcc memorystatus and dbcc memusage.

    Edited by - Allen_Cui on 06/26/2003 12:26:48 PM

  • June 26, 2003 at 12:37 pm

    #463327

    That's it. Thanks again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply