Version

Argent Advanced Technology 1304-L and above

Date

Friday, 3 May 2013

Summary

Argent Advanced Technology has been enhanced with a new Rule category ‘SQL Compilation Ratio Rules‘ in Argent for SQL Server to calculate the ratio between ‘SQL Compilations/sec‘ and ‘Batch Requests/sec‘

Click For Full Size

Example 1:

‘SQL Compilation Ratio Rules‘ calculate the ratio between ‘SQL Compilations/sec‘ and ‘Batch Requests/sec‘. Rule ‘SQL_COMPILATIONS_RATIO_SQL2008_APPROACHING_LIMIT‘ is broken if ‘SQL Compilations/sec‘ and ‘Batch Requests/sec‘ ratio is between 0.05 and 0.1

Click For Full Size

Example 2:

‘SQL Compilation Ratio Rules‘ calculate the ratio between ‘SQL Compilations/sec‘ and ‘Batch Requests/sec‘. Rule ‘SQL_COMPILATIONS_RATIO_SQL2008_EXCEEDING_LIMIT‘ is broken if ‘SQL Compilations/sec‘ and ‘Batch Requests/sec‘ ratio is between 0.1 and 0.3

Click For Full Size

Example 3:

‘SQL Compilation Ratio Rules‘ calculate the ratio between ‘SQL Compilations/sec‘ and ‘Batch Requests/sec‘. Rule ‘SQL_COMPILATIONS_RATIO_SQL2008_MAJOR_OVERLOAD‘ is broken if ‘SQL Compilations/sec‘ and ‘Batch Requests/sec‘ ratio is greater than 0.3

Click For Full Size

Technical Background

N/A

Resolution

N/A