KBI 311419 Enhancement: New Rule Category Database Long Running SQL Query Reporting Only Rule In Argent for SQL Server
Version
Argent Advanced Technology 3.1A-1601-T10 and later
Date
Tuesday, 21 June 2016
Summary
Argent for SQL Server has been enhanced with a new Rule category ‘Database Long Running SQL Query Reporting Only Rules’ for the reporting of SQL query statistics
Technical Background
The ‘Database Long Running SQL Query Reporting Only Rules’ saves the SQL query execution statistics such as query text, last execution time, execution count, total worker time, total elapsed time etc. to the database table named
‘ARGSOFT_SQL_SERVER_QRY_STATICTICS’
Argent Reports can use this table for reporting
There is an option named ‘Days To Keep Old Data’, that deletes all records older than specified number of days
Please see the screenshot of the Rule:
Resolution
Upgrade to Argent Advanced Technology 1601-T10 or later