Delivering a SQL Server Health Check
WHAT’S IN THIS CHAPTER?
- Understanding the importance of collecting diagnostic and baseline information
- Using instance level diagnostic queries
- Understanding how Microsoft releases updates for SQL Server
- Using database level diagnostic queries
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
THE IMPORTANCE OF A SQL SERVER HEALTH CHECK
One of the first things you should do with a new or unfamiliar database server is collect as much information as possible about that server — from the details of the hardware and storage subsystem, to the operating system, up to the SQL Server instance itself. You need to know what you are dealing with — whether it is a poorly configured, “ancient” server with a completely inadequate storage subsystem, or, hopefully something much better. This information is a critical starting point for focusing your efforts to properly manage and optimize your database servers. As a database professional, there is really no excuse for not knowing the hardware and configuration details about each of your database servers.
This chapter walks you through a set of queries that you can use for your SQL Server health check, explaining what they mean and how to interpret the results. These queries start at the hardware and instance level, and then enable you ...