We currently use SQL Server 2005 that is on a Windows 2003 32 bit machine with max RAM (4 GB I think). The hardware is probably 6-8 years old.
We are working on switching over to a newer server. I'm not sure of all the specs, but the hardware is new and we it is Windows 2008 server 64 bit machine with 32 GB ram. Both old and new server used some type of RAID configuration. The network guy said the RAID on the new server should be more efficient. The new server also has SQL Server 2005 on it for now with plans to upgrade later this year.
While running a number of tests, we basically found that the READS are significantly faster and the WRITES are significantly slower. For testing purposes to research this issue, we have an .NET program sitting on a separate application server that runs 10000 inserts -- one at a time. On average for 1000 of these inserts, it take 0.53 seconds on the old server and 4.33 seconds on the new server. We ran this test a number of times and get the consistent execution time with each test. Our network guy monitored he new server during one of these test and said he is not seeing any issues jump out when looking at performance monitor statistics (RAM, page faults, disk I/O, etc).
Any ideas of what may be going on? Are there any SQL Server settings/options we can focus on?
Any help is appreciated. Thanks.