SQL Stored procedure times out
-
Monday, October 08, 2012 10:14 PM
I have a stored procedure that times when called as part of a monthend process unless the SQL service has been restarted or a database reindexing job has been run. The stored procedure has 2 parameters and returns about 200,000 rows in 10 seconds when called from outside the monthend process. The server is running SQL Server 2008 R2 and is allocated 26GB physical memory. can you please help
All Replies
-
Monday, October 08, 2012 10:27 PM
Would you please check-out below thread
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
- Proposed As Answer by Amy PengMicrosoft Contingent Staff Wednesday, October 10, 2012 7:28 AM
- Marked As Answer by Shulei ChenModerator Monday, October 22, 2012 10:01 AM
-
Tuesday, October 09, 2012 12:06 AMThank you Ahmed for the link. I will test the solutions and report back to the forum
Earnest
.png)
