This condition checks the number of rows that are present in the dbo.suspect_pages
table in the MSDB database, when the total count of records in the table is 900 the alert will fire. This is because the dbo.suspect_pages
table can only contain a maximum of 1000 records before it fills at which point any new suspect pages that are detected will not have information logged about them.