Solved

Barely any CPU used for ASP.NET/MySQL application

Posted on 2008-10-19
5
287 Views
Last Modified: 2012-06-21
I'm building an import utility for ASP.NET and MySQL. It imports contacts from a CSV or XLS file. The problem is my local dev machine (Windows 2K3, IIS 6, Celeron 1.8 ghz single core) imports contacts about 10 times faster than our server (Windows 2K8, IIS 7, 8-core intel xeon). I've noticed that when running this import on the server, it doesn't even use 1% of the processor, while my dev machine uses a lot more.

This import tool is pretty intense and a lot is going on with it. Is there some sort of processor cap that I can modify? I obviously don't want it using all 8 cores at once, but it doesn't even crack 1% cpu usage during the import operation and as a result is causing import operations to take incredibly long to complete.

Any ideas? Thanks.
0
Comment
Question by:redheaded
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 22755238
The biggest difference between and server and a workstation is that a server has to potentially deal with hundreds of requests at a time and workstation only one.

Because a server can't predict when the next request is coming they are conservative about rationing out CPU time.  Even if it was possible to modify the logic I wouldn't do it.

There could be other factors at play on your server.  For example, an AntiVirus solution on a server, firewalls et cetera can slow local file access that is outside the boundaries of a typical web application.

I'd suggest you use a free tool like 'Spotlight for Windows' from Quest software to see if there are I/O or other bottlenecks.
0
 

Author Comment

by:redheaded
ID: 22758331
I'll try that software.

What about understanding "queries per second"? How can I determine my average for both machines for comparison? Is there a manual way to change this, if there's a cap? Thanks.
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 500 total points
ID: 22760520
Hmm, this is tricky to explain but I'll try.  Changing the maximum workload the server can handle will not change the percentage assigned to each query.

Let's say that at 100% CPU usage the server can handle 100 queries.  So, that means at peak capacity 1 query uses 1% of resources.  If I set a web application to only process a maximum of 20 queries it doesn't mean that at peak capacity those 20 queries have 5% capacity as a maximum.  Setting a maximum capacity doesn't automatically increase the maximum CPU given to each query.

What you are asking for is a way to control the core preemptive multi-tasking scheduling within Windows.  In my experience there is no way to control it.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question