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?
PS: is it unfair compairing these systems?