troubleshooting Question

SQL web server 2008 R2 express performamce diferences

Avatar of Simon Cripps
Simon CrippsFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft IIS Web ServerMicrosoft SQL Server 2008Windows Server 2008
13 Comments2 Solutions584 ViewsLast Modified:
Hi,
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.

Specs are
Development
Windows 7 Professional version 6.1.76
x64 based PC 2.93Duo CPU
4GB RAM
MS SQL Server 2008 Express 10.0.25

Virtual server
Windows Web server 2008 R2 ver. 6.1.76
x64 based
2 x quad core AMD 2.29 GHz processors
4GB RAM
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.
ASKER CERTIFIED SOLUTION
kmalte

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros