June 26, 2003 at 11:37 am
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
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
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
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
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