Winsoup
asked on
Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I've recently moved the database that hosts some of our intranet sites on. It's been moved from a Windows 2003 server with SQL Server 2000 installed to a Windows 2008R2 server with SQL Server 2008 installed. The database moved successfully and the sites have been pointed to the new server.
The issue now is the sites will be available for roughly 30-45 minutes and then becomes inaccessible for about 15 minutes. It goes up and down without any interference from me. Any ideas? Below is a log of the error.
Server Error in '/' Application.
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlE xception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj) +194
System.Data.SqlClient.TdsP arserState Object.Rea dSniError( TdsParserS tateObject stateObj, UInt32 error) +527
System.Data.SqlClient.TdsP arserState Object.Rea dSni(DbAsy ncResult asyncResult, TdsParserStateObject stateObj) +359
System.Data.SqlClient.TdsP arserState Object.Rea dNetworkPa cket() +88
System.Data.SqlClient.TdsP arser.Cons umePreLogi nHandshake (Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable) +72
System.Data.SqlClient.TdsP arser.Conn ect(Server Info serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +291
System.Data.SqlClient.SqlI nternalCon nectionTds .AttemptOn eLogin(Ser verInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
System.Data.SqlClient.SqlI nternalCon nectionTds .LoginNoFa ilover(Str ing host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlI nternalCon nectionTds .OpenLogin Enlist(Sql Connection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlI nternalCon nectionTds ..ctor(DbC onnectionP oolIdentit y identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlC onnectionF actory.Cre ateConnect ion(DbConn ectionOpti ons options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.D bConnectio nFactory.C reatePoole dConnectio n(DbConnec tion owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.D bConnectio nPool.Crea teObject(D bConnectio n owningObject) +433
System.Data.ProviderBase.D bConnectio nPool.User CreateRequ est(DbConn ection owningObject) +66
System.Data.ProviderBase.D bConnectio nPool.GetC onnection( DbConnecti on owningObject) +499
System.Data.ProviderBase.D bConnectio nFactory.G etConnecti on(DbConne ction owningConnection) +65
System.Data.ProviderBase.D bConnectio nClosed.Op enConnecti on(DbConne ction outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlC onnection. Open() +122
System.Data.Common.DbDataA dapter.Qui etOpen(IDb Connection connection, ConnectionState& originalState) +31
System.Data.Common.DbDataA dapter.Fil lInternal( DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
System.Data.Common.DbDataA dapter.Fil l(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
System.Data.Common.DbDataA dapter.Fil l(DataSet dataSet, String srcTable) +92
System.Web.UI.WebControls. SqlDataSou rceView.Ex ecuteSelec t(DataSour ceSelectAr guments arguments) +1297
System.Web.UI.DataSourceVi ew.Select( DataSource SelectArgu ments arguments, DataSourceViewSelectCallba ck callback) +19
System.Web.UI.WebControls. DataBoundC ontrol.Per formSelect () +142
System.Web.UI.WebControls. BaseDataBo undControl .DataBind( ) +73
System.Web.UI.WebControls. GridView.D ataBind() +4
System.Web.UI.WebControls. BaseDataBo undControl .EnsureDat aBound() +82
System.Web.UI.WebControls. CompositeD ataBoundCo ntrol.Crea teChildCon trols() +72
System.Web.UI.Control.Ensu reChildCon trols() +87
System.Web.UI.Control.PreR enderRecur siveIntern al() +44
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt) +842
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618
The issue now is the sites will be available for roughly 30-45 minutes and then becomes inaccessible for about 15 minutes. It goes up and down without any interference from me. Any ideas? Below is a log of the error.
Server Error in '/' Application.
--------------------------
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlE
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlI
System.Data.SqlClient.TdsP
System.Data.SqlClient.TdsP
System.Data.SqlClient.TdsP
System.Data.SqlClient.TdsP
System.Data.SqlClient.TdsP
System.Data.SqlClient.TdsP
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlC
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.SqlClient.SqlC
System.Data.Common.DbDataA
System.Data.Common.DbDataA
System.Data.Common.DbDataA
System.Data.Common.DbDataA
System.Web.UI.WebControls.
System.Web.UI.DataSourceVi
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.Control.Ensu
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Page.Process
--------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"The issue now is the sites will be available for roughly 30-45 minutes and then becomes inaccessible for about 15 minutes."
Are there any SQL Jobs running on the new box at the time when the performance suffers??
Please use SQL Dashboard reports for a better picture of what's happeneing with your SQL server (including very usefull Missing Index report):
http://www.microsoft.com/download/en/details.aspx?id=22602
how to make it work on SQL 2008:
http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx
Are there any SQL Jobs running on the new box at the time when the performance suffers??
Please use SQL Dashboard reports for a better picture of what's happeneing with your SQL server (including very usefull Missing Index report):
http://www.microsoft.com/download/en/details.aspx?id=22602
how to make it work on SQL 2008:
http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx
ASKER
Here's a log file bhess1 and I'll look into what you mentioned lcohan and get back to you.
Date,Source,Severity,Messa ge
10/11/2011 15:16:21,spid51,Unknown,Us ing 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
10/11/2011 15:16:21,spid51,Unknown,At tempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
10/11/2011 15:16:21,spid51,Unknown,Us ing 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
10/11/2011 15:16:21,spid51,Unknown,At tempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
10/11/2011 15:16:21,spid51,Unknown,Us ing 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
10/11/2011 15:16:21,spid51,Unknown,At tempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
10/11/2011 15:16:21,spid51,Unknown,FI LESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:21,spid51,Unknown,Co nfiguratio n option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
10/11/2011 15:16:21,spid51,Unknown,FI LESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:21,spid51,Unknown,Co nfiguratio n option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
10/11/2011 15:16:21,spid51,Unknown,FI LESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:21,spid51,Unknown,Co nfiguratio n option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
10/11/2011 15:16:21,Server,Unknown,SQ L Server is now ready for client connections. This is an informational message; no user action is required.
10/11/2011 15:16:21,Server,Unknown,Th e SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/patriots.wincraft .local:143 3 ] for the SQL Server service.
10/11/2011 15:16:21,Server,Unknown,Th e SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/patriots.wincraft .local ] for the SQL Server service.
10/11/2011 15:16:21,Server,Unknown,De dicated admin connection support was established for listening locally on port 1434.
10/11/2011 15:16:21,Server,Unknown,Se rver is listening on [ 127.0.0.1 <ipv4> 1434].
10/11/2011 15:16:21,Server,Unknown,Se rver is listening on [ ::1 <ipv6> 1434].
10/11/2011 15:16:21,Server,Unknown,Se rver named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
10/11/2011 15:16:21,Server,Unknown,Se rver local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSER VER ].
10/11/2011 15:16:21,Server,Unknown,Se rver is listening on [ 'any' <ipv4> 1433].
10/11/2011 15:16:21,Server,Unknown,Se rver is listening on [ 'any' <ipv6> 1433].
10/11/2011 15:16:21,Server,Unknown,A self-generated certificate was successfully loaded for encryption.
10/11/2011 15:16:21,spid6s,Unknown,Re covery is complete. This is an informational message only. No user action is required.
10/11/2011 15:16:21,spid13s,Unknown,S ervice Broker manager has started.
10/11/2011 15:16:21,spid13s,Unknown,T he Database Mirroring protocol transport is disabled or not configured.
10/11/2011 15:16:21,spid13s,Unknown,T he Service Broker protocol transport is disabled or not configured.
10/11/2011 15:16:21,spid10s,Unknown,S tarting up database 'tempdb'.
10/11/2011 15:16:20,spid10s,Unknown,C learing tempdb database.
10/11/2011 15:16:20,spid19s,Unknown,S tarting up database 'ISIT'.
10/11/2011 15:16:20,spid18s,Unknown,S tarting up database 'WSS_Search2_REDWING'.
10/11/2011 15:16:20,spid17s,Unknown,S tarting up database 'WSS_Search_REDWING'.
10/11/2011 15:16:20,spid16s,Unknown,S tarting up database 'STS_REDWING_1'.
10/11/2011 15:16:20,spid15s,Unknown,S tarting up database 'WSS_AdminContent'.
10/11/2011 15:16:20,spid14s,Unknown,S tarting up database 'sharepoint'.
10/11/2011 15:16:20,spid13s,Unknown,S tarting up database 'msdb'.
10/11/2011 15:16:20,spid6s,Unknown,In formationa l: No full-text supported languages found.
10/11/2011 15:16:20,spid10s,Unknown,S tarting up database 'model'.
10/11/2011 15:16:20,spid6s,Unknown,Se rver name is 'PATRIOTS'. This is an informational message only. No user action is required.
10/11/2011 15:16:20,spid6s,Unknown,Th e resource database build version is 10.50.1600. This is an informational message only. No user action is required.
10/11/2011 15:16:20,spid6s,Unknown,St arting up database 'mssqlsystemresource'.
10/11/2011 15:16:20,spid6s,Unknown,SQ L Trace ID 1 was started by login "sa".
10/11/2011 15:16:20,spid6s,Unknown,FI LESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:20,spid6s,Unknown,Re covery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
10/11/2011 15:16:20,spid6s,Unknown,St arting up database 'master'.
10/11/2011 15:16:20,Server,Unknown,No de configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
10/11/2011 15:16:20,Server,Unknown,Us ing dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
10/11/2011 15:16:20,Server,Unknown,De tected 8 CPUs. This is an informational message; no user action is required.
10/11/2011 15:16:20,Server,Unknown,SQ L Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
10/11/2011 15:16:20,Server,Unknown,Re gistry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER VER\MSSQL\ DATA\maste r.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER VER\MSSQL\ Log\ERRORL OG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER VER\MSSQL\ DATA\mastl og.ldf
10/11/2011 15:16:20,Server,Unknown,Th is instance of SQL Server last reported using a process ID of 5024 at 10/11/2011 3:16:13 PM (local) 10/11/2011 8:16:13 PM (UTC). This is an informational message only; no user action is required.
10/11/2011 15:16:20,Server,Unknown,Lo gging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER VER\MSSQL\ Log\ERRORL OG'.
10/11/2011 15:16:20,Server,Unknown,Au thenticati on mode is MIXED.
10/11/2011 15:16:20,Server,Unknown,Sy stem Manufacturer: 'Dell Inc.'<c/> System Model: 'PowerEdge R710'.
10/11/2011 15:16:20,Server,Unknown,Se rver process ID is 1724.
10/11/2011 15:16:20,Server,Unknown,Al l rights reserved.
10/11/2011 15:16:20,Server,Unknown,(c ) Microsoft Corporation.
10/11/2011 15:16:20,Server,Unknown,Mi crosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) <nl/> Apr 2 2010 15:48:46 <nl/> Copyright (c) Microsoft Corporation<nl/> Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Date,Source,Severity,Messa
10/11/2011 15:16:21,spid51,Unknown,Us
10/11/2011 15:16:21,spid51,Unknown,At
10/11/2011 15:16:21,spid51,Unknown,Us
10/11/2011 15:16:21,spid51,Unknown,At
10/11/2011 15:16:21,spid51,Unknown,Us
10/11/2011 15:16:21,spid51,Unknown,At
10/11/2011 15:16:21,spid51,Unknown,FI
10/11/2011 15:16:21,spid51,Unknown,Co
10/11/2011 15:16:21,spid51,Unknown,FI
10/11/2011 15:16:21,spid51,Unknown,Co
10/11/2011 15:16:21,spid51,Unknown,FI
10/11/2011 15:16:21,spid51,Unknown,Co
10/11/2011 15:16:21,Server,Unknown,SQ
10/11/2011 15:16:21,Server,Unknown,Th
10/11/2011 15:16:21,Server,Unknown,Th
10/11/2011 15:16:21,Server,Unknown,De
10/11/2011 15:16:21,Server,Unknown,Se
10/11/2011 15:16:21,Server,Unknown,Se
10/11/2011 15:16:21,Server,Unknown,Se
10/11/2011 15:16:21,Server,Unknown,Se
10/11/2011 15:16:21,Server,Unknown,Se
10/11/2011 15:16:21,Server,Unknown,Se
10/11/2011 15:16:21,Server,Unknown,A self-generated certificate was successfully loaded for encryption.
10/11/2011 15:16:21,spid6s,Unknown,Re
10/11/2011 15:16:21,spid13s,Unknown,S
10/11/2011 15:16:21,spid13s,Unknown,T
10/11/2011 15:16:21,spid13s,Unknown,T
10/11/2011 15:16:21,spid10s,Unknown,S
10/11/2011 15:16:20,spid10s,Unknown,C
10/11/2011 15:16:20,spid19s,Unknown,S
10/11/2011 15:16:20,spid18s,Unknown,S
10/11/2011 15:16:20,spid17s,Unknown,S
10/11/2011 15:16:20,spid16s,Unknown,S
10/11/2011 15:16:20,spid15s,Unknown,S
10/11/2011 15:16:20,spid14s,Unknown,S
10/11/2011 15:16:20,spid13s,Unknown,S
10/11/2011 15:16:20,spid6s,Unknown,In
10/11/2011 15:16:20,spid10s,Unknown,S
10/11/2011 15:16:20,spid6s,Unknown,Se
10/11/2011 15:16:20,spid6s,Unknown,Th
10/11/2011 15:16:20,spid6s,Unknown,St
10/11/2011 15:16:20,spid6s,Unknown,SQ
10/11/2011 15:16:20,spid6s,Unknown,FI
10/11/2011 15:16:20,spid6s,Unknown,Re
10/11/2011 15:16:20,spid6s,Unknown,St
10/11/2011 15:16:20,Server,Unknown,No
10/11/2011 15:16:20,Server,Unknown,Us
10/11/2011 15:16:20,Server,Unknown,De
10/11/2011 15:16:20,Server,Unknown,SQ
10/11/2011 15:16:20,Server,Unknown,Re
10/11/2011 15:16:20,Server,Unknown,Th
10/11/2011 15:16:20,Server,Unknown,Lo
10/11/2011 15:16:20,Server,Unknown,Au
10/11/2011 15:16:20,Server,Unknown,Sy
10/11/2011 15:16:20,Server,Unknown,Se
10/11/2011 15:16:20,Server,Unknown,Al
10/11/2011 15:16:20,Server,Unknown,(c
10/11/2011 15:16:20,Server,Unknown,Mi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Turns out the sites connecting to SQL were going up and down due to a netword card not being configured correctly. After the NIC was fixed, the sites have been up ever since.
I've awarded you both points for helpful suggestions on making our SQL server run smoother. Thanks for the help!
I've awarded you both points for helpful suggestions on making our SQL server run smoother. Thanks for the help!
I recommend REBUILD not REORGANIZE as it's an online operation and UPDATE STATISTICS at table level - please see my answer at:
https://www.experts-exchange.com/questions/27383064/Create-Statistics-how-to-decide-what-to-create.html?cid=1133&anchorAnswerId=36931674#a36931674