Version

Argent Advanced Technology 3.1A-1601-T18 and later

Date

Wednesday, 24 August 2016

Summary

Argent for SQL Server Query Rule has been enhanced by implementing a facility to set SQL query time out for Transact-SQL Query Rules

Technical Background

SQL Query Rules execute a single customizable SQL statement, stored procedure, or a Transact-SQL block on a specified SQL Server instance/database

SQL statement and stored procedure uses ODBC driver to execute the given statements

Transact-SQL uses SQL Management Objects (SMO) to execute the statements

There is an option named SQL Time Out to set the number of seconds a statement is given to run before failing with a time out error

Please see the below screenshot:

Click For Full Size

The default ODBC connection time out is 15 seconds

For slow running SQL queries and stored procedures, it is important to increase the time out value as it uses ODBC driver to executes the query statements

The default time out of SMO APIs used in Argent for SQL Server to execute the Transact-SQL statements is 10 minutes

So the SQL Query Rules ignores the specified time out value to execute the Transact-SQL statements as it uses SMO objects and it got 10 minutes default time-out

There are situations to override the default 10 minutes due to network access problems, excessive query processing time, and so on

Argent for SQL Server has been enhanced the SQL query Rule to use the specified SQL Time Out value to execute the Transact-SQL statements

Resolution

Upgrade to Argent Advanced Technology 1601-T18 or later