SQL Saturday #434 Holland - Slides

John Martin

Published On: October 2, 2015

Categories: Baselines, Monitoring 0

On Saturday I presented my session Monitoring SQL Server, Key performance metrics and how to interpret them at SQL Saturday #434 in Utrecht, Holland.
I have already uploaded the deck to the SQL Saturday website where you can download them from the Schedule page, I am also posting them here.

One thing that I thought I would pull out is information around the MSDB table dbo.suspect_tables, this is where SQL Server stores information on corrupt pages that it encounters. Monitoring and managing this table is a good idea as it can give you insight into the presence of corruption in addition to your normal DBCC CHECKDB jobs, defense in depth if you will. It is important to bear the following things in mind with this table;

  • There is a 1000 row limit in the table
  • One row for each page that generated an 823 or 824 (limited by table row limit)
  • When a page is repaired the record is updated but not removed (you need a maintenance task)

Finally, if you attended my session (or any of the other great sessions) we would appreciate your feedback for the sessions you attended, and the event organizers would appreciate your event feedback too. Without this feedback we won't know what worked and what did not, thanks.