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
Author
Message
Posted Wednesday, October 10, 2012 2:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 07, 2014 5:48 AM
Points: 66, Visits: 251
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.

Thanks
Malik Adeel Imtiaz


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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
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 2008, 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