★ wanayoo — archive 1999 https://github.com/sqlcollaborative/dbachecks/issues/764Nouvelle recherche | Portail wanayoo
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New-Check: msdb.dbo.suspect_pages nearing row limit #764

Closed
jpomfret opened this issue Apr 10, 2020 · 0 comments
Closed

New-Check: msdb.dbo.suspect_pages nearing row limit #764

jpomfret opened this issue Apr 10, 2020 · 0 comments
Assignees

Comments

@jpomfret
Copy link
Collaborator

@jpomfret jpomfret commented Apr 10, 2020

New Check

Number of rows in msdb.dbo.suspect_pages.

What would you like to check?

  • any rows in this table indicates that SQL Server has found corrupt pages
    • depending on the event_type they may no longer be suspect
  • if row count gets to 1000, SQL Server stops recording into the table.

What should be configurable for the results of the check ?

Number of rows in the table to alert on?

What should be able to be excluded from being tested ?

N/A

Additional information

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/manage-the-suspect-pages-table-sql-server?view=sql-server-ver15

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

1 participant
You can’t perform that action at this time.