Found abnormal XdesId

%3CLINGO-SUB%20id%3D%22lingo-sub-3294800%22%20slang%3D%22en-US%22%3EFound%20abnormal%20XdesId%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3294800%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20figure%20out%20what%20this%20is.%20Getting%20this%20in%20the%20SQL%20Server%20Log%20sometimes.%20Got%20this%20during%20the%20night%20today%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markdown%22%3E%3CCODE%3EFound%20abnormal%20XdesId%20%5B576733327%3A0%5D%20on%20page%20%5B1%3A42142828%5D%2C%20slot%202%2C%20Max%20XdesId%20%5B145078457%3A0%5D%2C%20forceStrip%200%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERunning%20SQL%20Server%202019%20CU15%20on%20Windows%20Server%202022%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%2FJens%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3294800%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%202019%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3295007%22%20slang%3D%22en-US%22%3ERe%3A%20Found%20abnormal%20XdesId%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3295007%22%20slang%3D%22en-US%22%3EYes%20%40blake13%20It's%20enabled%20on%20all%20Databases%20that%20I%20have.%3CBR%20%2F%3EGood%20if%20it's%20ignorable%20message%2C%20but%20super%20annoying%20when%20it%20spams%20the%20log%20with%20500%2B%20rows.%3CBR%20%2F%3EI%20will%20schedule%20a%20CHECKDB%20to%20see%20if%20there%20is%20a%20issue.%20No%20issue%20on%20my%20%22Restore%2FDBCC%20server%22%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3294976%22%20slang%3D%22en-US%22%3ERe%3A%20Found%20abnormal%20XdesId%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3294976%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306493%22%20target%3D%22_blank%22%3E%40JensNilsson%3C%2FA%3E%26nbsp%3B--%26nbsp%3B%20Do%20you%20have%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Faccelerated-database-recovery-concepts%3Fmsclkid%3D2d341390c55011ec87eb123ee4c3deaa%26amp%3Bview%3Dsql-server-ver15%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eaccelerated%20database%20recovery%20enabled%3C%2FA%3E%20for%20any%20of%20the%20databases%20hosted%20on%20the%20SQL%20instance%3F%26nbsp%3B%20You%20can%20determine%20whether%20any%20databases%20have%20accelerated%20database%20recovery%20enabled%20using%20the%20query%20below.%26nbsp%3B%20I%20believe%20that%20feature%20will%20generate%20this%20message.%26nbsp%3BWhile%20I%20think%20this%20message%20can%20be%20safely%20ignored%2C%20I%20would%20recommend%20a%20database%20integrity%20check%20when%20possible%20just%20to%20be%20safe.%26nbsp%3B%20Take%20care.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-sql%22%3E%3CCODE%3ESELECT%20%5Bname%5D%2Cis_accelerated_database_recovery_on%20FROM%20sys.databases%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi All

 

I'm trying to figure out what this is. Getting this in the SQL Server Log sometimes. Got this during the night today again.

 

 

Found abnormal XdesId [576733327:0] on page [1:42142828], slot 2, Max XdesId [145078457:0], forceStrip 0

 

 

 

Running SQL Server 2019 CU15 on Windows Server 2022

 

Kind regards

/Jens

2 Replies

Hi @JensNilsson --  Do you have accelerated database recovery enabled for any of the databases hosted on the SQL instance?  You can determine whether any databases have accelerated database recovery enabled using the query below.  I believe that feature will generate this message. While I think this message can be safely ignored, I would recommend a database integrity check when possible just to be safe.  Take care.

 

SELECT [name],is_accelerated_database_recovery_on FROM sys.databases

 

Yes @blake13 It's enabled on all Databases that I have.
Good if it's ignorable message, but super annoying when it spams the log with 500+ rows.
I will schedule a CHECKDB to see if there is a issue. No issue on my "Restore/DBCC server"

Kind regards