New [about 10 days old] 10 User SBS 2003 R2 Premium, with SQL installed.
Plenty of [SuperMicro] hardware, AMD dual core 2.6Ghz, 4GB memory, 146GB SAS
15K Drives.
Performance is generally excellent, but on occasion, when doing something
[could not isolate any one particular task] on the server, the screen appears
to freeze for a couple of seconds then we can continue to accomplish the task.
On the performance chart, most times [but not all times] the paging/sec will
spike. The Average Disk Queue Time [maximum <.125] and % Processor [maximum
< 4.99] almost remains constant during the same time for the few seconds this
event is happening.
I was looking through some logs and did not see anything that jumps out at
me, but I may be looking in the wrong place.
Where should I be looking?
What should I be looking to see?
Any help and suggestions would be greatly appreciated.
Thank you,
Ed Podowski
One more note...some times during a remote access the connection to the
server is lost. I get the same symptoms as described above. I will
re-establish a remote session and continue to work.