April 10, 2014 at 9:33 am
Question: Is there a time specific setting set for timing out a long running query or a extended lock event?? if so where is it set?
April 10, 2014 at 9:52 am
Timeouts are a client-side setting, SQL doesn't give up on queries unless it's told to (kill session or attention call from client app)
There's a lock wait setting somewhere (sp_configure I think), but it's instance-wide.
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
April 10, 2014 at 11:26 am
What about the query governor setting for queries? Should that be set? If so any recommendations?
April 10, 2014 at 11:48 am
It depends. It's definitely not something I'd set everywhere. It doesn't look at the time queries take, it looks at their cost and that's an estimate. It doesn't stop a running query, it prevents queries from even starting if their cost exceeds the threshold set.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply