I'm having performance issues on my SQL server. I'm running SQL 2005 Standard on an HP ProLiant DL380 G5, dual quad-cores, 4 GB RAM, 8 physical disks (set up as 3 partitions - C: mirrored, D: RAID5, and E: RAID5), Windows Server 2003 Standard edition.
We are running Orion Network Performance Monitor and the database resides on my SQL server (Orion server is a separate physical server). Orion is having major performance issues and all is pointing to the SQL server at this point. The disk queue lengths on the SQL box are averaging 22 right now and maxing at like 160. All of the SQL data is located on the D: partition.
What can I do to increase the performance of this box? According to SolarWinds, we should not be seeing these issues with the hardware we are running. Our Orion install is only polling 800 nodes...with the hardware we have, SolarWinds says that we should be able to poll up to 8,000 nodes.
Any help at all would be greatly appreciated!