February 11, 2014 at 7:43 am
All of a sudden I'm getting this error for remote connections to SQL Server:
Lock Request period time out exceeded. (Microsoft SQL Server, Error: 1222)
I changed the timeout property from 600 to 0.
There is not that much activity on the Server.
I'm still getting the error.
Any suggestions would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 11, 2014 at 7:46 am
Problem went away.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 12, 2014 at 9:23 pm
Recompile the query plan could resolve the issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 13, 2014 at 6:30 am
free_mascot (2/12/2014)
Recompile the query plan could resolve the issue.
Thanks for the advice.
There is not an SP involved.
It is a Bulk Insert in an SSIS Package.
Thanks again.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply