We just started using GFI server monitoring for the various servers in our network, and we're getting a lot of message alerts regarding processor performance and memory. When viewing the performance monitor on each server, the processor performance will rarely spike and typically is very low. The memory, though, shows a maximum of over 3,000 pages per second and an average of +/- 80. I understand that the pages/sec number should be closer to 20, so I'm just wondering what configurations I can check to make sure everything is optimized. The servers are running SQL server on them, but nothing else besides random file sharing (hardly any at all).
Windows Server 2003 Standard R2 SP2
3.5GB usable RAM (1.7 taken by sqlservr process)
Intel Core2 Duo E4600
Windows Server 2000 SP4
2GB Usable RAM (1.6 taken by sqlservr process)
Intel Xeon 3.0
FYI: There are far more alerts happening on the 2003 servers than on the 2000 ones. I've already tried moving the paging file to another partition without benefit. Adding another drive simply for the effect of reducing these alerts isn't an option, as we don't notice performance decrease. Just the alerts.