October 24, 2009 at 12:27 am
Few Days back i was asked to troubleshoot Perfromance issues on one of our Production Server
Recieved the folloiwng error
Error: 701, Severity: 17, State: 193.
There is insufficient system memory to run this query.
Environment: Windows Server 2003 Sp2
SQL Server 2005 Build 4035
AWE Enabled
Lock pages in memory set for SQl Service account
Max Server memory 24 Gigs
total Server memory 32 Gigs
I am attaching the output of DBCC Memory Status, can someone help me with this
Also since I am pretty much new to Perfromance troubleshooting, i have a few questions
1. Do Error 701 signify MTL Pressure, Bpool Pressure or VAS Pressure
2. If it is found that the Server is having MTL pressure, can we find out what processes is causing this memory Crunch
3. Memory node Id = 0
VM Reserved = 1582632 KB
VM Committed = 388260 KB
AWE Allocated = 24576000 KB
SinglePage Allocator = 806000 KB
MultiPage Allocator = 88608 KB
From the Above piece of information, we see that AWE allocated is 24 Gigs, max Server memory is 24 Gigs.
SO i believe Bpool is assignd 24 Gigs.
However Single Page allocator (SPA) is only 800 MB on Node 0 and I believe SPA allocates pages in the Bpol.
Then does this just show the SPA assigned in the VAS that would be used to
Map the larger Area under AWE
4.Do The Sum of Single Page allocator and Multi page allocator across all Clerks, Memory cache etc sum up to the
Single Page allocator and Multi page allocator across all nodes.
Thanks,
Mani
October 26, 2009 at 12:18 am
Have a look at the perfmon.exe and check the important performance counters related to memory.
This link will help you to find out the relavance of some of those counters.
http://blogs.msdn.com/teekamg/archive/2007/11/06/sql-server-memory-related-performance-counters.aspx
..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply