Reply
Random IIS hangs with ASP/ MSSQL/Win2003
Old 07-25-2004, 06:09 PM Random IIS hangs with ASP/ MSSQL/Win2003
Junior Talker

Posts: 1
I manage a large website with >10,000 pages. For over a year, the
website has been randomly freezing up, requiring a restart of IIS.
The website was recently moved from a Windows 2000/IIS 5/SQL Server to
a Windows 2003/IIS 6/MSDE configuration, and the freezes intensified
from every few weeks to every few hours. With IIS 5, I could just
restart IIS, but now I must restart the IIS service. The IIS
administrator shows absolutely nothing wrong, and there is no pattern
I see to the hangs, other than high website loads. I believe that the
ASP pages seem to crash before HTML or Perl pages in IIS when the
hangs occur.

I have had several hypotheses about the problem: It runs Perl for the
blog, which uses 100% of the CPU power when posts I made. I have
since moved it to Apache to host the blog. I removed all the
Application.Lock commands from ASP. I have tried to close all unused
ODBC connections. I have tried DSN and DSN-less connections. I have
removed all the Application-level variables I can and trimmed
global.asa to the essentials. I have tried to optimized the
efficiency of the SQL code (had to, since we moved to MSDE.) I have
gone through Google and MS technote articles without luck.

More background: The ASP code for the website is eight years old,
with parts being gradually converted to .Net. I am considering moving
much of the website to MySQL (would this help?) The database
connections currently use a single DSN session variable for the entire
site. The MSDE db goes over the 8 query limit hourly, which I believe
is non-significant. I set the IIS recycle settings tighter than the
default to try to kill any hanging connections. I tried running the
IIState tool before and during hangs, without any obvious patterns,
but will send it if you’re interested.

I did see a quite of few of these in running and hung IIState dumps:

Thread ID: 12
System Thread ID: 914
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Possible ASP page. Possible DCOM activity
Executing Page: Unable to locate ASP page

We are quite desperate to get this issue resolved, and will give you
any information or pay whatever it takes to do so.
GreeedyCapitali is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 08-15-2004, 08:46 PM we had the same problem
Junior Talker

Posts: 1
Hi

I had the same problem but I have my own hosting companies with different web sites, here is what I did and the problem was resolved may be you can do the same.

In IIS 6 MMS
1) Expand Application Pool
2) Click on the Application pool that your site belongs too
3) right mous click and open properties
4) change the default work process recycling to 60 min
5) also at the bottom select memory recycling and select the limits. I did not change the defaults.

After I did that everything was fine. Our server has been runing for 2 weeks now with out a restart before I had to restart IIS every 1 hour sometimes faster. Let me know if this helped.

James

http://www.hostingonnet.com
jameszarr is offline
Reply With Quote
View Public Profile
 
Old 08-26-2004, 07:24 PM
spudge's Avatar
Skilled Talker

Posts: 77
Location: Kirkland, WA
iPowerWeb is set up funky too, and does the same thing.

Last edited by spudge : 08-29-2004 at 05:10 PM.
spudge is offline
Reply With Quote
View Public Profile Visit spudge's homepage!
 
Old 10-08-2004, 11:18 AM
Junior Talker

Posts: 1
http://www.microsoft.com/downloads/d...DisplayLang=en

Try this link: it's the IIS Debug Tool
sparky is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Random IIS hangs with ASP/ MSSQL/Win2003
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.14643 seconds with 12 queries