i have a sql-server 2005 on a win2003 32-bit (3,5GB RAM) 4 CPU Server with a RAID 5 Disk-Array which perform at 1/10 of a virtual 2008-SQL-Server Win2008 32 Bit 2GB RAM Raid 5 Server.
The Job is to delet 8,5 Mio Records out of one table of one database. After 6 hours the virtual server as a test-environment has finished the job. At the same time the productive-server has done allmost 1 Mio deletions. Whats wrong with that real win2003 server?
where to look, which parameters rule on a matter?
Peace
Ice
PS: is it unfair compairing these systems?
Most likely the production server has other requests to serve, so it has to share resources and wait on locks.
This suggestion on stackoverflow should solve your problem just fine.
I wouldn't think the performance difference would be that bad, but it all depends. I've benchmarked up to a 7 fold increase in application performance when changing from 03/sql05 to an 08/sql08 on the same hardware. You might try changing the parallelism to 1 on the 905 server. I've seen poorly hinted queries improve by doing that. In addition check to see what ram each one has, if there is any other disk I/O activity and what processor type. Remember that a 2.4 ghz nehalem processor can make a merom 3.2 ghz proc look like its running at half speed.
Look at the execution plans for the delete statement on both machines and see how they differ; make sure the stats are updated.