Random IIS timeouts related to SQL Server Activity

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)
ricorguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
dnojcdCommented:
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

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.