AWE Counters extremely high

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » AWE Counters extremely high

AWE Counters extremely high

Rate Topic

Display Mode

Topic Options

Author

Message

Megan Kelly

Posted Wednesday, January 30, 2008 11:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, September 21, 2009 3:35 PM
Points: 35, Visits: 77

I have SQL 2K server with 8GB memory and 11 databases (3 of which are over 15GB)...we'll call server A, and a nearly identical server with 4GB memory and 30 databases (most are between 1 and 3GB)...we'll call Server B.

Server A has extremely high AWE lookup maps/sec (Avg 8472), stolen maps/sec (Avg 15947), unmap calls/sec (Avg 14755), unmap pages/sec (Avg 18858)....and write maps/sec on Avg of 1???

Server B has AWE lookup maps/sec (Avg 153), stolen maps/sec (Avg 795), unmap calls/sec (Avg 776), unmap pages/sec (Avg 915)...and write maps/sec of 0.020 on Avg.

One could argue that the customers on Server A utilize our application far more than the customers on Server B....but with so many customers on Server B I find the rate of activity to be near the same.

Could someone point me in the right direction and help me determine why the AWE counters are so high on Server A?

Post #449567

Paul Randal

Posted Wednesday, January 30, 2008 7:24 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:23 PM
Points: 1,905, Visits: 1,601

Mu guess would be that the workload is a a lot higher on server A, plus you've got much more AWE memory for SQL Server to use - even so, it looks like the workloads are churning the memory somewhat. If two queries from separate customers are using lots of memory for disparate data, I'd expect to see what you're seeing.

Hope this helps

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Post #449773

free_mascot

Posted Wednesday, January 30, 2008 11:41 PM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:39 AM
Points: 1,768, Visits: 1,312

Looks like memory leak problem:

refer the sql server and do the AWE settings as per the articles

http://support.microsoft.com/kb/274750

Make sure you are using sql server enterprise edition; else assign sql server to use fixed memory of 2 gb.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Post #449821

Paul Randal

Posted Wednesday, January 30, 2008 11:56 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:23 PM
Points: 1,905, Visits: 1,601

Can you explain why it looks like a memory leak? I'm intrigued...

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Post #449823

free_mascot

Posted Thursday, January 31, 2008 12:21 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:39 AM
Points: 1,768, Visits: 1,312

Hello Paul,

FYI:

I was using sql server 7.0 standard edition RAM 2.0 GB. Memory setting Dynamic. Now we have upgraded the server to 4.0 GB.

After the memory upgrade the problem starts; server runs for a few days and suddenly went down. After the investigation we found that sql server eats up memory and there will be no memory left for the OS. After that we have fixed the memory settings to use fixed 2.0 GB and problem solved.

Hence I conclude that here one of the culprit COULD be Memory Leak.

Hope this will satisfy you.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Post #449830

Megan Kelly

Posted Thursday, January 31, 2008 9:00 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, September 21, 2009 3:35 PM
Points: 35, Visits: 77

What can I do to determine what queries/procedures are consuming the most memory? Other than physically running each one myself and monitoring the counters in a dev environment.

Post #450010

« Prev Topic | Next Topic »

Permissions