I am getting the below error in ffdc
com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
and whenever I get this error, the CPU utilization is at 100% and results in OutofMemory error after 15/20 mins.
so I increased the JVM size and number of threads for the particular JDBC connection, now whenever I get this error CPU is reaching 100% for 2 mins. Can someone please help in understanding this behavior(any exception causing CPU to be 100% utilized) and any possible resolution for it?
Thanks in advance.
This topic has been locked.
Pinned topic Lock request time out period exceeded
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
SystemAdmin 110000D4XK3556 Posts
Re: Lock request time out period exceeded2012-11-27T23:34:08ZThis is the accepted answer. This is the accepted answer.Check the lockTimeOut custom property of the datasource. It is likely set to never timeout.
The amount of time (in milliseconds) to wait for a lock before timing out. -1 indicates the attempt to acquire a lock never times out. 0 indicates the attempt times out immediately.
More importantly you might want to check why an attempt to get the lock takes longer than expected. Increasing the timeout or the threads or the heap size will likely just delay the issue but not fix it.
mmalc 10000036A9230 Posts
Re: Lock request time out period exceeded2012-12-06T09:31:00ZThis is the accepted answer. This is the accepted answer.See if this helps you