Time out expired when i execute stored procedure.

Question

Post reply

Time out expired when i execute stored procedure.

pankaj.kuchaliya

SSC Eights!

Points: 944
More actions
September 14, 2010 at 10:43 pm

#224060

Hi,
I have an stored procedure , when i execute this procedure it throws an exception "TIME OUT EXPIREd".
why this happened. i have attached the execution plan. please help me.
thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Though its good you have posted the plans, what statement is causing the Timeout ?

Clear Sky SQL
My Blog[/url]

pankaj.kuchaliya SSC Eights! Points: 944 More actions · Answer 2

Dave Ballantyne (9/15/2010)
Though its good you have posted the plans, what statement is causing the Timeout ?

when i call the stored procedure from front end then i display the time out expired.

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 3

Probably for the same reasons i have stated in your other thread

http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx

Clear Sky SQL
My Blog[/url]

pankaj.kuchaliya SSC Eights! Points: 944 More actions · Answer 4

pankaj.kuchaliya (9/15/2010)
Dave Ballantyne (9/15/2010)
Though its good you have posted the plans, what statement is causing the Timeout ?
when i call the stored procedure from front end then i display the time out expired.

it display the ---

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

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)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at RMI.RM_WS.Exec_sp_ETL_to_RPT()

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

I'm not reading through 10 plans to guess which is the problem. Do some investigation on your side, run the queries in Management Studio, and work out which of them are slow. Then post the query, table definitions, index definitions and execution plan.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 6

Did you able to solve this problem..i am working with this problem so let me know if you have solution

thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Please post new questions in a new thread. This is not a single problem with a single solution.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass