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