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
Monday, October 08, 2012 10:27 PM
Would you please check-out below thread
SQL Server Setup Team
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.
Tuesday, October 09, 2012 12:06 AMThank you Ahmed for the link. I will test the solutions and report back to the forum