Use awe to allocate memory windows 2008 r2

I have downloaded the VMMap tool from sysinternals. After intensive testing I was not able to detect any malfunction. To deal with this display issue I had to change our Nagios scripts which are monitoring SQL Server memory consumption to work correctly. I am now using the DMV sys. Office Office Exchange Server. Not an IT pro? Windows Client. Sign in. United States English.

Ask a question. Quick access. There are no special teachers of virtue, because virtue is taught by the whole community. Gail Shaw. Yes, if you have locked pages enabled you will see that the memory is allocated using the AllocPhysicalPages API call rather than the VirtualAlloc, that's how locked pages work, pages allocated via AllocPhysicaPages can't be paged out by the OS.

Thanks for the replies! I finally found that this morning after poking around at some things. Just misleading that it shows AWE which i interpreted as bit for locking the memory pages.

Okay, should I lower the Max. Couple of times, I've being receiving event id There is insufficient system memory in resource pool 'default' to run this query.

I'm wondering if it's because SQL is taking all the memory and thus generating that error? And you do not need to worry about SQL using a lot of memory.

Particularly if you didn't set default max limits, then SQL Server will use all the memory it can at the time. Depending on what that machine is doing, you'd want to maybe set a max. You say you have 12gb of memory. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed.