About the White Paper:
"SQL Server 2000 for experienced DBAs," Chapter 5, 'Monitoring and Tuning SQL Server'
Date published:
25 March 2003
About the White Paper:
Monitoring and tuning SQL Server is essential to maintaining a stable and efficient database. This chapter focuses on being a proactive DBA, giving you the tools and tips that will help you avoid those database snarls.
Learn all about Monitoring and Tuning in SQLServer in Chapter 5, 'Monitoring and Tuning SQL Sever,' from Brian Knight's book "SQL Server 2000 for experienced DBAs " with this series of book excerpts, courtesy of McGraw-Hill Osborne Media. (Published 2003)
Introduction
Nothing is more frustrating and monotonous for a DBA than having to
constantly monitor servers. My boss used to tell me, "More administrators
quit being a DBA because the monotony of DBA work." This chapter
focuses on being a proactive administrator, and provides techniques you can use to
actually enjoy your weekends without being paged.
Chapter 5 excerpts: Monitoring and tuning SQL Server
- Managing messages
- System monitor
- Peformance counters
- System monitor logging
- System monitor alerts
- Trace flags
- Alerts
- Setting job notifications
- Forecasting growth
- sqldiag
| 
