monitor
#monitor#2577

2577

Product Name Event ID 2577 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_IAM_CHAIN_SEQUENCE_OUT_OF_ORDER Mess

Product

Name

Event ID

2577

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

DBCC_IAM_CHAIN_SEQUENCE_OUT_OF_ORDER

Message

Text

Chain sequence numbers out of order in the Index Allocation Map (IAM) chain for object

ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit ID A_ID (type TYPE). Page P_ID1 with

sequence number SEQUENCE1 points to page P_ID2 with sequence number SEQUENCE2.

Every Index Allocation Map (IAM) page has a sequence number. The sequence number is the

position of the IAM page within the IAM chain. The rule is that sequence numbers increase by

one for each IAM page. IAM page,

P_ID2

, has a sequence number that does not follow this rule.

Run hardware diagnostics and correct any problems. Also examine the Microsoft Windows

system and application logs and the SQL Server error log to see whether the error occurred as

the result of hardware failure. Fix any hardware-related problems that are contained in the logs.

Expand table