Hi

No, i wont feel bad, i'll just give our DBA some grief, will make me feel much better 🙂

We have Raid 5

C, D, E logical volumes

Sorry not sure about the...

Hi Gail

Thanks for your help, it seems that increasing the memory allocation solved most of the problems in one go.

With the offending database/application running AND a test SP that calls...

Hi Gail

Thanks for your reply, i appreciate it, will get back to this thread tomorrow when the office is open.

Yes i saw the full scans are pretty high, does that...

Hi Gail, Thanks for the help: Here goes:

32 bit system 147483647 MB (default) (its a 2*Quad, 8gb raid 5 fyi)

Note: The server is in production so it is in use....