Brand new DELL T610 with dual quad core cpu. 16GB memory 3x600GB SAS in RAID5.
Totally updated Windows SBS 2008 with all service packs and patches.
SQL Express Edition 2008 R2 and SQL 2008 running three databases.
Resource Monitor in the Os reports 36% physical memory in use.
Page file fixed size 24559MB
Antivirus on the server was Trend Micro Worry Free Business Advanced. Tried uninstalling it without any improvement on the issue.
10 client PC's.
The server is ok after restart, but after a few days it starts paging. We see it in performance monitor on the counter "Page Faults/sec". It keeps apging in spikes everey few seconds. Sometimes it's persistent and then we also see a rise in "Avg Disk Queue Length" which again indicates heavy paging.
The server is so slow sometimes that the mouse pointer is jittery.
The users see the slowness in the SQL databases responding slowly, and then again their client software.
When I check resource monitor in the OS and see what processes are using memory, it changes all the time. When I use iexplore, then that process is paging with up to several thousand page faults per minute. So I cannot pinpoint one culprit. Its just all over the OS.
This is a tough one, I'd give 2000 points if I could.
Thanks for helping!