KBI 310437 Enhancement: New Rule Category Average Disk Second Per Write Rules In Argent for SQL Server
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 ‘Average Disk Second Per Write Rules‘ in Argent for SQL Server to find the Average Disk sec/Write
Example 1:
‘Average Disk Second Per Write Rules‘ measure average time in seconds to write data to the disk. Rule ‘AVG_DISK_SECOND_WRITE_SQL2008_APPROACHING_LIMIT‘ is broken if the average time to write data to the disk is between 0.008 and 0.02 seconds
Example 2:
‘Average Disk Second Per Write Rules‘ measure average time in seconds to write data to the disk. Rule ‘AVG_DISK_SECOND_WRITE_SQL2008_AT_LIMIT‘ is broken if the average time to write data to the disk is between 0.01 and 0.03 seconds
Example 3:
‘Average Disk Second Per Write Rules‘ measure average time in seconds to write data to the disk. Rule ‘AVG_DISK_SECOND_WRITE_SQL2008_MAJOR_OVERLOAD‘ is broken if the average time to write data to the disk is greater than 0.03 seconds
Technical Background
N/A
Resolution
N/A