Hi Newbie,

We are doing statistics updates on regular basis and Affinity is taken care by SQL server internally i guess.

when I execute sysprocess it is showing all the running id's with memory usage.

I have already mentioned I kept cap on sql server around 24GB i.e. 80% to sql server and remaining 20% to OS(total RAM is 32 GB)...