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