Chapter 13Managing and monitoring SQL Server
Maintaining indexes and statistics
Maintaining database file sizes
Monitoring databases by using DMVs
Capturing Windows performance metrics with DMVs and data collectors
Chapter 11 discusses 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? In this chapter, we lay the foundation for the what and why of Microsoft SQL Server management, including key dynamic management views (DMVs) along the way, and how to set up extended events (the replacement for traces). We ...
Get SQL Server 2017 Administration Inside Out, First Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.