<div>
good question, well, yes but I never tested it ;-)
</div>


good question, well, yes but I never tested it ;-)

<div>
Query governor setting simply does not execute the query. It detects the problem BEFORE it occurs.<br />

</div>


Query governor setting simply does not execute the query. It detects the problem BEFORE it occurs.


<div>
hey... that's true... but such an unused feature in my domain!!!! it works based on the estimated excution time (not actual).
</div>


hey... that's true... but such an unused feature in my domain!!!! it works based on the estimated excution time (not actual).

<div>
<div class="content wysiwyg-content">
If i check the &quot;use query governor to prevent long running queries&quot; and set a time limitunder &nbsp;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?
</div>
</div>


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?

MS SQL 2005 query governor

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.