Je suis having a performance problem in a site we've made, et Je suis pas exactly sure how to start diagnosing it.
The short description is: Nous avons a très small site (http://hearablog.com) avec très little traffic, in a crappy dedicated server, CPU is toujours très high, sometimes it stays at 100% for minutes, et w3wp.exe is taking le plus of it. A typical scenario is w3wp.exe takes 60%, et SQL Server takes about 30%.
Our DB is pretty small too.
Long description et more details:
-
The site is hosted in a très crappy server by Cari.Net. From le beginning we had le feeling that le server didn't assez behave correctly, like certains things would take juste too long, so this could be a configuration problem depuis le get go. It may aussi be that we are getting a virtual server tandis que we're supposed to have a dedicated one, bien que we have no evidence that'd indicate this, except for le fact that le server tends to be assez slow.
-
The server is Windows 2008 Standard 64-bit, avec SQL 2008 Express
-
Hardware is a Celeron 2.80 GHz, 1Gb RAM
-
The website is developed in ASP.Net MVC, using Entity Framework for data access.
-
Now, this is pretty crappy hardware, mais i've had autre servers avec these guys, avec equivalent (or worse) HW, et performance is much better than this one. That said, le autre servers have W2003 et SQL2005, et Je suis using ASP.Net "WebForms" 2.0, no MVC, no LINQ, no EF; so Je suis pas sure si going to 2008 / le autre stuff means a big performance penalty is expected.
-
Je suis serving MP3 files (5-20 Mb) regularly, qui is a slightly unusual load, maybe that is causing certains kind of problems?
Would that cause w3wp to use a lot of CPU?
-
Disk usage seems très low. Memory is usually around 90%, mais disk usage seems to indicate c'est pas paging much.
-
I get tons of e-mails chaque day about SQL timeouts, for queries taking over 30 seconds, bien que tous our queries are pretty straightforward (or should be, mais EF may be screwing it up).
Ceci est what resource monitor looks like in one of these "sprints" of 100% CPU, in case il y a anything utile there.
And a snapshot of certains performance counters:
Now, what confuses me très much is that CPU usage of w3wp is juste so high.
It ne devrait pas be doing much really...
So mon questions are...
Is there tout way of finding out "what" it is doing? Maybe even profile it?
Any performance counters I should be looking at?
Is this to be expected given this hardware/software configuration?
Is this could be cause by certains kind of configuration failure, où would you start looking?
Thank you VERY much.
Daniel Magliola