Link to home
Start Free TrialLog in
Avatar of Winsoup
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.SqlException: 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +527
   System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +359
   System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() +88
   System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable) +72
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +291
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1297
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +19
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +44
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618
SOLUTION
Avatar of Brendt Hess
Brendt Hess
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
One of theiggest difference after you move from SQL 2000 to 2005/2008 is that you MUST maintain your indexes and update your statistics periodicaly otherwise you SQL query performance suffers a lot - well ad-hoc queris from your APP as well.

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
"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
Avatar of Winsoup
Winsoup

ASKER

Here's a log file bhess1 and I'll look into what you mentioned lcohan and get back to you.

Date,Source,Severity,Message
10/11/2011 15:16:21,spid51,Unknown,Using '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,Attempting 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,Using '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,Attempting 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,Using '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,Attempting 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,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:21,spid51,Unknown,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
10/11/2011 15:16:21,spid51,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:21,spid51,Unknown,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
10/11/2011 15:16:21,spid51,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:21,spid51,Unknown,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
10/11/2011 15:16:21,Server,Unknown,SQL 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,The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/patriots.wincraft.local:1433 ] for the SQL Server service.
10/11/2011 15:16:21,Server,Unknown,The 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,Dedicated admin connection support was established for listening locally on port 1434.
10/11/2011 15:16:21,Server,Unknown,Server is listening on [ 127.0.0.1 <ipv4> 1434].
10/11/2011 15:16:21,Server,Unknown,Server is listening on [ ::1 <ipv6> 1434].
10/11/2011 15:16:21,Server,Unknown,Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
10/11/2011 15:16:21,Server,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
10/11/2011 15:16:21,Server,Unknown,Server is listening on [ 'any' <ipv4> 1433].
10/11/2011 15:16:21,Server,Unknown,Server 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,Recovery is complete. This is an informational message only. No user action is required.
10/11/2011 15:16:21,spid13s,Unknown,Service Broker manager has started.
10/11/2011 15:16:21,spid13s,Unknown,The Database Mirroring protocol transport is disabled or not configured.
10/11/2011 15:16:21,spid13s,Unknown,The Service Broker protocol transport is disabled or not configured.
10/11/2011 15:16:21,spid10s,Unknown,Starting up database 'tempdb'.
10/11/2011 15:16:20,spid10s,Unknown,Clearing tempdb database.
10/11/2011 15:16:20,spid19s,Unknown,Starting up database 'ISIT'.
10/11/2011 15:16:20,spid18s,Unknown,Starting up database 'WSS_Search2_REDWING'.
10/11/2011 15:16:20,spid17s,Unknown,Starting up database 'WSS_Search_REDWING'.
10/11/2011 15:16:20,spid16s,Unknown,Starting up database 'STS_REDWING_1'.
10/11/2011 15:16:20,spid15s,Unknown,Starting up database 'WSS_AdminContent'.
10/11/2011 15:16:20,spid14s,Unknown,Starting up database 'sharepoint'.
10/11/2011 15:16:20,spid13s,Unknown,Starting up database 'msdb'.
10/11/2011 15:16:20,spid6s,Unknown,Informational: No full-text supported languages found.
10/11/2011 15:16:20,spid10s,Unknown,Starting up database 'model'.
10/11/2011 15:16:20,spid6s,Unknown,Server name is 'PATRIOTS'. This is an informational message only. No user action is required.
10/11/2011 15:16:20,spid6s,Unknown,The 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,Starting up database 'mssqlsystemresource'.
10/11/2011 15:16:20,spid6s,Unknown,SQL Trace ID 1 was started by login "sa".
10/11/2011 15:16:20,spid6s,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
10/11/2011 15:16:20,spid6s,Unknown,Recovery 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,Starting up database 'master'.
10/11/2011 15:16:20,Server,Unknown,Node 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,Using 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,Detected 8 CPUs. This is an informational message; no user action is required.
10/11/2011 15:16:20,Server,Unknown,SQL 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,Registry startup parameters: <nl/>       -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/>       -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/>       -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
10/11/2011 15:16:20,Server,Unknown,This 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,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
10/11/2011 15:16:20,Server,Unknown,Authentication mode is MIXED.
10/11/2011 15:16:20,Server,Unknown,System Manufacturer: 'Dell Inc.'<c/> System Model: 'PowerEdge R710'.
10/11/2011 15:16:20,Server,Unknown,Server process ID is 1724.
10/11/2011 15:16:20,Server,Unknown,All rights reserved.
10/11/2011 15:16:20,Server,Unknown,(c) Microsoft Corporation.
10/11/2011 15:16:20,Server,Unknown,Microsoft 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)
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Winsoup

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!