SQL web server 2008 R2 express performamce diferences
Posted on 2010-09-13
I am running a daily batch job to update a sizable amount of data. I have been testing this on my development machine and the job takes about 2 hours. I have migrated this to my production virtual server and the job now takes 12hrs.
I believe that the SQL servers are set up the same – but I am happy to check specific if they are pointed out.
All data is stored locally relative to the running job (either on the server or the PC)
The Development PC is used only for development. The Virtual server hosts the website application that uses this data. as the job runs this has a crippling impact on the website to make it unusable. Viewing Task manager on the server as the job is running the CPU hovers around 20% and the RAM at 2.5GB of the available 4GB. I currently have very little traffic to the website and do not want to encourage traffic till this is resolved.
Windows 7 Professional version 6.1.76
x64 based PC 2.93Duo CPU
MS SQL Server 2008 Express 10.0.25
Windows Web server 2008 R2 ver. 6.1.76
2 x quad core AMD 2.29 GHz processors
MS SQL Server 2008 Express 10.0.1
Any suggestions on why there is a difference and how to resolve this would really be much appreciated. This is preventing my web site from running effectively for 10hrs a day as the job runs.