Post navigation

SQL Server Tracking Suspect Pages

Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table called suspect_pages? Well it does, but the question I want answering is what happens if the page within the suspect pages table is fixed? Does it automatically get removed/updated or do we as the administrators have to do anything manually?

Let’s find out.

Here is a very basic setup. Using the following query, I will find the page ID I want to ruin. That being page 126.

DBCC IND (N'ZoraDB', N'people', -1);
GO

I then do some offset calculations and sprinkle some “magic dust”. Then I am ready to run CHECKDB.