S
Sandhya Kumar
Hi,
We have a huge table having around 29579242 Rows.The table is huge and there
is no clustered index on the table. There are a couple of non-clustered
indexes.
We have started experiencing these errors. We increased the command timeout
to 120 (2 minutes) but the error isstill occuring on Insert. Data is being
inserted 1 row at a time and is not transactional. Any ideas?
Thanks
Sandhya
With the Message: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
We have a huge table having around 29579242 Rows.The table is huge and there
is no clustered index on the table. There are a couple of non-clustered
indexes.
We have started experiencing these errors. We increased the command timeout
to 120 (2 minutes) but the error isstill occuring on Insert. Data is being
inserted 1 row at a time and is not transactional. Any ideas?
Thanks
Sandhya
With the Message: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)