Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

How to Set Minimum and Maximum memory in AWE SQL2005 Expand / Collapse
Posted Wednesday, October 10, 2012 2:58 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 20, 2015 2:36 AM
Points: 75, Visits: 294
Quit right Let me check in the testing environment.

One thing more. Now i am in another situation.

In Production i have set 11 GB to MAXIMUM and 7 Gb to MINIMUM as mentioned in my earlier replies
and when i ran my queries (Heavy load queries).
it touches to 11 GB and after that with out completion's of query memory drop down to 2 to 3 GB. And my query stuck because

1) Memory drops
2) Query required memory and there is no memory.

Why this is happening.

Malik Adeel Imtiaz

Post #1370772
Posted Wednesday, October 10, 2012 3:05 AM



Group: General Forum Members
Last Login: Today @ 8:56 AM
Points: 43,454, Visits: 40,597
SQl doesn't drop it's memory usage unless restarted or the server is under memory pressure or max server memory is reconfigured to a low value. Please read chapter 4 of that book.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1370777
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse