this is pankaj here, i am facing a problem in sql server
the problem is that if i am runnig a long query/stored proc that takes time near about 8 - 10 min then the occupied memory for buffer pool is not releasing by sql srv .
the memory option of my sql srv instance is dynamically allocate memory.
b/c of this after 1-1.5 hours most of my system memory occupies by sql srv and my system goes slow down.
if i want to release that mem so i have stop and restart sql srv manually so it works proper for next same hours.
so please provide me solutin for this ....
waiting for u r kind reply