inevercheckthis2002 (5/6/2014)
spaghettidba (5/5/2014)
Ok, so no resource exhaustion event.You should monitor the memory counters in Windows and see if they get too low.
If this is a SQL Server only box, you could lower the Maximum Server Memory configuration parameter.
Both hosts in the cluster have 16 GB RAM - with AWE enabled.
I have the maximum server memory set to 13500.
I would err on the side of caution and allocate less then ramp up, not the other way around. Try setting max mem to 10 or 11Gb initially.
Is this 64 bit or 32bit OS\SQL?
Do you have LPIM privilege granted to the sql server service account?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉