Web Wiz Support and Community Forums : small issue

Web Wiz Support and Community Forums : small issue - rare hangs of 8.0? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 00:13:26 +0000 Fri, 24 Mar 2006 14:01:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18882 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[small issue - rare hangs of 8.0? : Thank you! I see... Yes, I faced...]]> https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102291.html#102291 Author: ask023
Subject: 18882
Posted: 24 March 2006 at 2:01pm

Thank you! I see... Yes, I faced with hangs when new DB created.

Let's see what happen in near future

]]> Fri, 24 Mar 2006 14:01:49 +0000 https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102291.html#102291 <![CDATA[small issue - rare hangs of 8.0? : Simple recovery model and auto...]]> https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102251.html#102251 Author: WebWiz-Bruce
Subject: 18882
Posted: 24 March 2006 at 12:34pm

Simple recovery model and auto shrink for the database are also recommended so your database doesn't get to large.]]> Fri, 24 Mar 2006 12:34:05 +0000 https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102251.html#102251 <![CDATA[small issue - rare hangs of 8.0? : The only time I ever had an...]]> https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102250.html#102250 Author: WebWiz-Bruce
Subject: 18882
Posted: 24 March 2006 at 12:32pm

The only time I ever had an issue which sounds similar was in testing when I was creating the database on the SQL Server, sometimes it would slow down after creating the new database, but restarting the SQL Service would clear the issue up and it wouldn't appear again.

Maybe some strange issue with SQL Server when you create a new database.

Also I only ever saw this issue with SQL Server 2005 (I was using the Express version)

Edited by -boRg- - 24 March 2006 at 12:32pm]]> Fri, 24 Mar 2006 12:32:08 +0000 https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102250.html#102250 <![CDATA[small issue - rare hangs of 8.0? : Bruce, thank you for your reply! I...]]> https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102210.html#102210 Author: ask023
Subject: 18882
Posted: 23 March 2006 at 6:58pm

Bruce, thank you for your reply!

I use local SMTP server and local SQL server...If I face with the same issue, I will restart IIS, test it, restart SQL, test it.

Actually, I saw "Please wait" message for ~1min after logon, but server was not busy (CPU ~20%, memory ~50% free)...I restarted SQL+IIS and issue was gone

I think it very hard to troubleshoot such issues. Probably we may ask gurus to publish they recommendations for typical SQL/IIS settings? Like "Simple mode", "Autoshrink", etc for SQL

Edited by ask023 - 23 March 2006 at 6:59pm]]> Thu, 23 Mar 2006 18:58:55 +0000 https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102210.html#102210 <![CDATA[small issue - rare hangs of 8.0? : The SQL code in version 8 has...]]> https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102150.html#102150 Author: WebWiz-Bruce
Subject: 18882
Posted: 23 March 2006 at 11:39am

The SQL code in version 8 has been gone through many 100's of times to make sure it performs as fats as it can.

You should not have any delays of 5-60 seconds and in tests I have never seen delays of this amount.

It sounds like it could be a server issue:

It could be network delays (if not using 'localhost' database.
Try restarting the SQL Server and see if that solves the issue
The server or servers maybe busy doing something else, again try rebooting
If you are adding a new post it could be a delay in contacting the SMTP server to send post notifications that is coursing the delay (try using a 'localhost' SMTP server)
]]> Thu, 23 Mar 2006 11:39:11 +0000 https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102150.html#102150 <![CDATA[small issue - rare hangs of 8.0? : Hello, 8.0 RC1, Win2003SP1, SQL2005...]]> https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102098.html#102098 Author: ask023
Subject: 18882
Posted: 22 March 2006 at 11:15pm

Hello,

8.0 RC1, Win2003SP1, SQL2005 Std

I noticed several hangs when forum waits for 5-60 sec with simple operations - like using admin menu or new post adding

It may be fixed by IIS+SQL restart. Does anyone face with this issue? Are there any clues to fix it?

Thank you in advance,

Sergey

]]> Wed, 22 Mar 2006 23:15:04 +0000 https://forums.webwiz.net/small-issue-rare-hangs-of-8-0_topic18882_post102098.html#102098