Satish-219904 (4/6/2010)
From your responses so far,I will add make the max. memory change and add the sql service account to "lock pages in memory" option. Hopefully these two changes will fix the paging issues that i have been seeing.
set your min memory too, How much do you want sql server to have minimum?
i would set it to 4GB and change if you need.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉