CHAPTER 7
Creating a SQL Health Repository
You now have enough knowledge and technical foundation to put together all you know so far to create and build a DBA and SQL health repository. In this chapter, I will expand on the tools and scripts I have been discussing.
Laying the Repository Groundwork
Since you will be collecting a whole host of metadata, performance measures, and statistics regarding the health of your SQL Server on a continuous basis, you will need a place to store and review this information. One readily available place to store and review collected data is an Excel spreadsheet. Here you can create a tab for each set of specific ...
Get Healthy SQL : A Comprehensive Guide to Healthy SQL Server Performance 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.
