May 2023
Intermediate to advanced
992 pages
31h 14m
English
Maintain and monitor SQL Server
Previous chapters covered the importance and logistics of database backups, but what else do you need to do on a regular basis to maintain a healthy SQL Server?
This chapter lays the foundation for the what and why of Microsoft SQL Server monitoring, based on dynamic management objects (DMOs), Database Consistency Checker (DBCC) commands, Extended Events (which ...