Chapter 7. Conducting a SQL Server 2005 Health Check
If SQL Servers are left unkept or unmanaged, maintaining them can become overwhelming. Even then, some of the most maintained SQL Servers still have room for improvement. Health checks are meant to assist you, as database administrator (DBA), by providing more information on current issues or uncovering potential issues and then recommending best practice recommendations or resolutions based on experience.
Typically, organizations budget a health check annually as a part of their routine maintenance plan. However, health checks are not always planned events.
Consider this example: You just inherited the responsibility to manage a SQL Server 2005 environment. In this case, it would be a good ...
Get Microsoft® SQL Server 2005 Management and Administration 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.
