Databases Reference
In-Depth Information
15
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
remtitle.cgi?isbn=1118177657
on the Download Code tab. The code is in the
Ch15HealthCheck.sql
download.
THE IMPORTANCE OF A SQL SERVER HEALTH CHECK
One of the i rst 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 stor-
age 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 coni gured, “ancient” server with a
completely inadequate storage subsystem, or, hopefully something much better. This informa-
tion 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 coni guration details about each of your database servers.
Search WWH ::
Custom Search