KBI 311368 Enhancement: New Rule Category SQL Database Physical/Allocation Consistency Check Rule In Argent for SQL Server
Version
Argent Advanced Technology 3.1A-1601-T6 and later
Date
Wednesday, 6 April 2016
Summary
Argent for SQL Server has been enhanced with a new Rule category ‘SQL Database Physical/Allocation Consistency Check Rules’ to monitor the integrity of the physical structure of the page and record headers and the allocation consistency of the database
Technical Background
There is a new Rule in Argent for SQL Server to monitor the physical integrity of all the objects in the specified databases
This Rule checks the physical consistency of the database, detects the torn pages (page was not successfully written to disk), detects the checksum failures, and detects the common hardware failures that can compromise a user’s data
This Rule internally uses DBCC CHECKDB Transact-SQL statement to accomplish the functionality
DBCC CHECKDB may take considerably long time to complete depending upon the size and structure of the database
So Argent strongly recommends running this Rule in Relator using option ‘Spawn New Monitor Engine Process’
Below screenshot shows the sample Relator configuration of the Rule:
Resolution
Upgrade to Argent Advanced Technology 1601-T6 or later