I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same configuration but with an additional disk with 2TB of space. The database server runs SQL Server 2008 R2. The two machines are connected through a crossover connection. The application processes large loads of data from .csv files located in the webserver and stores them to the database. The data transfer and the number of items being processed per minute is very low compared to our benchmark times, which were set on a staging environment with a Web Server and Database Server running only 4 gb of ram. The staging environment processed a single .csv file at the rate of 6000 items per minute. The same file processed in the live environment ran at the rate of 2500 per minute. The staging environment, however is not running through cross cables but is using a standard switch. Suggestions as to why there is a drop in performance are welcome.
Check that you are not getting packet errors. Ensure that the auto configuration for the nics is working properly or hard code the values for speed, duplex, etc. This used to be a common problem, but has improved over the last decade with better nics and switches.