Marios Philippopoulos (3/18/2011)

---

I would suggest that you set a value for the max-mem setting value to say 2 or 3 GB.

Keep in mind that max-memory refers to the buffer-pool area...

kchant (3/17/2011)

---

You're right, AWE is not required on a 64 Bit system running 64 Bit version of SQL, it could just be that what you're using that box for has...

mnDBA (3/15/2011)

---

Out of curiosity, why do you think it would not work OK? I too usually leave 2GB (more on larger servers) to the OS/AV/Backup. However, in your...

456789psw (3/18/2011)

---

very simple....

watch your page life expectancy if this drops below 500 then you should start adding memory.....there are other numbers to look out for as well....but look at the...

Thanks for the reply David!

I had a look at these two links but still don't know what I should do.

I performance of SQL itself seems ok. On 64 bit version,...