?
Solved

Random IIS timeouts related to SQL Server Activity

Posted on 2006-03-25
3
Medium Priority
?
350 Views
Last Modified: 2010-08-05
I've got an e-Commerce site that I've inherited that's having seemingly random issues.  Throughout the day I see anywhere from 4 to 10 of the sites at a time become unresponsive on my network monitoring tool that is monitoring port 80 on each of the sites I have on the server.  It's also monitoring the IP for each of the sites and the services on the server, neither of which are having issues.  These timeouts last 15 seconds to a minute on average.  During the times, users on the site get timed out.

At the time when these timeouts occur, the system that we've got in place sends an unhandled exception notice to me along these lines;

Application Name Name Changed
Log Date Thursday, March 23, 2006
Function Name ExecuteReader
Source File Name http://www.namechanged.com/where/Default.aspx 

4 error details

Error Message Exception of type System.Web.HttpUnhandledException was thrown.
Error Source System.Web
Target System.Data.SqlClient.SqlDataReader ExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean)
Inner Exception Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Stack Trace at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at namechanged.common.cart.GetDataReader(String sqlText)
at namechanged.common.cart.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()
Base Exception Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

4 http request details

Application Path /
HTTP Method GET
Is Secure (SSL) False
URL /where/Default.aspx
Referrer URL  
Total Bytes 0
User Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
User Address removed
User Host removed
Client Browser IE 6.0
Client Platform Win2000
Cookies Enabled True
JavaScript Enabled True
Is Client AOL False
JavaScript Version 1.2
DOM Version 1.0
Postback Request False
Cookies ASP.NET_SessionId
[expires: 1/1/0001]
[domain: ]
[path: /]
: removed
sessiontracker
[expires: 1/1/0001]
[domain: ]
[path: /]
: removed
 
Form  
Query String  
Session AccountLevel: 1
userid: removed
IsLoggedIn: 0
NavLevel1: /Default.aspx
Title1: Home
 
Server Variables ALL_HTTP: HTTP_CONNECTION:Keep-Alive
HTTP_ACCEPT:*/*
HTTP_ACCEPT_ENCODING:gzip, deflate
HTTP_ACCEPT_LANGUAGE:en-us
HTTP_COOKIE:ASP.NET_SessionId=removed; sessiontracker=removed
HTTP_HOST:www.namechanged.com
HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)

ALL_RAW: Connection: Keep-Alive
Accept: */*
Accept-Encoding: gzip, deflate
Accept-Language: en-us
Cookie: ASP.NET_SessionId=qcntgf20wln1222uns1lqebv; sessiontracker=removed
Host: www.namechanged.com
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)

APPL_MD_PATH: removed
APPL_PHYSICAL_PATH: removed\Namechanged\
AUTH_TYPE:
AUTH_USER:
AUTH_PASSWORD:
LOGON_USER:
REMOTE_USER:
CERT_COOKIE:
CERT_FLAGS:
CERT_ISSUER:
CERT_KEYSIZE:
CERT_SECRETKEYSIZE:
CERT_SERIALNUMBER:
CERT_SERVER_ISSUER:
CERT_SERVER_SUBJECT:
CERT_SUBJECT:
CONTENT_LENGTH: 0
CONTENT_TYPE:
GATEWAY_INTERFACE: CGI/1.1
HTTPS: off
HTTPS_KEYSIZE:
HTTPS_SECRETKEYSIZE:
HTTPS_SERVER_ISSUER:
HTTPS_SERVER_SUBJECT:
INSTANCE_ID: 818792427
INSTANCE_META_PATH: removed
LOCAL_ADDR: removed
PATH_INFO: /where/Default.aspx
PATH_TRANSLATED: removed
QUERY_STRING:
REMOTE_ADDR: removed
REMOTE_HOST: removed
REMOTE_PORT: 4066
REQUEST_METHOD: GET
SCRIPT_NAME: /where/Default.aspx
SERVER_NAME: www.namechanged.com
SERVER_PORT: 80
SERVER_PORT_SECURE: 0
SERVER_PROTOCOL: HTTP/1.1
SERVER_SOFTWARE: Microsoft-IIS/6.0
URL: /where/Default.aspx
HTTP_CONNECTION: Keep-Alive
HTTP_ACCEPT: */*
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_ACCEPT_LANGUAGE: en-us
HTTP_COOKIE: ASP.NET_SessionId=removed; sessiontracker=removed
HTTP_HOST: www.namechanged.com
HTTP_USER_AGENT: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
0
Comment
Question by:ricorguy
1 Comment
 
LVL 10

Accepted Solution

by:
dnojcd earned 2000 total points
ID: 16319457
Check the SQL server if any SQL Agent Jobs that were running and areinterrupting  the application.

Try to increae the Connection Timeout and the Connect Lifetime (for pooling) in your connection string(s)

Also check this article to set the command timeout
http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=357
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

850 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