January 30, 2008 at 11:17 am
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?
January 30, 2008 at 7:24 pm
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
January 30, 2008 at 11:41 pm
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."
January 30, 2008 at 11:56 pm
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
January 31, 2008 at 12:21 am
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."
January 31, 2008 at 9:00 am
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply