Hello I have an HP server configured for RAID 1+0 using 2 SATA disks. I'm pretty new to handling servers also.
The server has had the same OS(Windows Server 2003) on it for a while so I'm not sure of what all it has been through.
It has a dual core P4 cpu running at 3ghz. 512M Ram.
The server runs very slowly.. I am not sure what is making it so slow though. There is not much performance different between when it has nearly no RAM free and when it has over 100M of RAM free. The only thing it is used for is a SVN server and hosting a low activity development SQLExpress database. Yet at times it can take over 1 second to perform a simple
SELECT * FROM TABLE where the table only has like 5 records in it.
The CPU is not maxing out or anything either. It hardly ever gets above 25% usage.
So my only idea is disk access. But even with a disk speed test I can't be sure that is where the bottle neck is. I've tried doing some performance monitoring, but the only odd thing I'm seeing is a large amount of Pages/Sec.(idles at close to zero and peaks at over 1000 while accessing the database and such).
TL;DR: How can I tell where the performance bottle neck is on my server in terms of disk, CPU, or memory, or something else?