I have one SQL 2008 server running on a Windows 2008 R2 platform using local storage. The stats on the server are as follows
-HP DL385 G5P
-2x AMD 2382 CPU's
-P400 controller wi battery wite cache
-OS and SQL application are installed on different logical volumes
-Physical Memory usage averages around ~95%
-Server host 68 DB's
Every now and then users have complained of sometime slow access from the DB server. I'm not a DBA but I'm trying to use Activity Monitor and unsure if the following values are good or bad or what they mean...
All values are for Cumulative Wait Time (SEC)
Network I/O - 44883
Logging - 70002
Latch - 13883
Buffer Latch - 553
Memory - 2
Buffer I/O - 9983
Thanks in advance for the help...