w3wp.exe is killing me

[78mike78]

I am running a asp.net website and the website runs fast sometimes and runs slow other times...
I have checked network connections, disk monitor, memory usage....everything seem to be very low,but w3wp.exe, which i think is used by the asp.net.... any suggestions on what i can do to optimize my server..
I have coverd IIS optimization, hardware....i am only left with this slow responding process...it uses access as the database.

 

[ca8msm]

everything seem to be very low,but w3wp.exe, which i think is used by the asp.net

You're right, it is the worker process that serves the ASP.NET requests which would point to the application you've developed being memory intensive.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[78mike78]

Actually i didnt write this....we had a third party consultant to create this website, and it runs okay...sometimes you can fly trough the pages sometimes its slow..i am trying to figure out why....Again, i have done all the basic hardware tests on it and didnt find any bottlenecks.. I am not sure what to
this is the website.

http://www.brendanvacations.com

 

[jbenson001]

Well, it is really hard to help you. You said you have checked some standard issues. So, it looks like it must be down to the code. Unless you have the source code and can analyize it, it will be almost impossible to help with this problem.

 

[78mike78]

If something is wrong with the code, is it possible that the server would be fast sometimes and slow others?
I have the source code, and we have a guy studying the source code in house....
Any suggestions on what i should check on the source code?
i am not a programmer, so sorry if the question sounds crazt

 

[jbenson001]

Well, if you have someone in house, then that is good. He will have to check what can be improved. He can look into caching to improve performance and reduce hits to the DB. Check image types/sizes etc.

 

[78mike78]

The entire website is DB based..with access... i dont know if thats the problem....
the biggest mistery to me is trying to figure out why sometimes its fast, somtimes its slow...that has me puzzled.

 

[jbenson001]

If you can, convert to sql server, you can get sql server express for free. That will be fine for a small site. And is easiy converted to a full version of sql server if needed.

 

[78mike78]

Thanks...how hard is it to convert from Access to SQL express?

 

[jbenson001]

That's hard to say. There are differences between the 2 obviously. For example, I know access has separate date and time datatypes for a table column, sql server does not, it is a datetime. Not sure if Access has an Identity type of column like sql server. This is valuable for using as a primary key because you don't have to maintain it, sql server does it for you. It would be best to get someone who knows sql server to convert it for you. Or, you can download it, and just start to play with it and see what you come up with.

 

[78mike78]

Thanks.. i will try migrating over from Access to SQL express, to see how if it helps the random slowness... I hate working on random issues, rather than something that doesnt work all the time..easier to troubleshoot.

Thanks to all of you for your advice.
MK