MS SQL 2005 query governor

If i check the "use query governor to prevent long running queries" and set a time limitunder  Connections in the SQL server properties of the MS SQL SErver Management studio - will this kill the queries that are causing blocking and/or become blocked when they exceed the running time?
martini60123Asked:
Who is Participating?
 
ptjcbConnect With a Mentor Commented:
Yes, chhapia_chintak is right - the query governor will estimate how long the query will take to produce results and it will not run the query if it is longer than your proposed time.  This can be a saving grace for those ad hoc queries but if a query legitimately needs to run long then it will not run at all. Be prepared.

For blocks and deadlocks you could add Try/Catch to your stored procs - this link will give some examples: http://www.sql-server-performance.com/art_deadlock_sql_2005.asp
0
 
Einstine98Commented:
good question, well, yes but I never tested it ;-)
0
 
chhapia_chintakCommented:
Query governor setting simply does not execute the query. It detects the problem BEFORE it occurs.
0
 
Einstine98Commented:
hey... that's true... but such an unused feature in my domain!!!! it works based on the estimated excution time (not actual).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.