Chapter 11. Monitoring and Tuning SQL Server
IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:
MONITOR SQL SERVER (Pages 372 – 398)
Using the SQL Profiler (Page 373)
Using System Monitor (Page 377)
Using Activity Monitor (Page 388)
Implementing DDL Triggers (Page 391)
Using SQL Server Audit (Page 394)
TUNE SQL SERVER (Pages 398 – 405)
Using Resource Governor (Page 398)
Managing Data Compression (Page 403)
In this chapter we discuss monitoring and tuning for performance in server instances and databases. We use monitoring and tuning with SQL Server 2008 to see how an instance or a particular database is performing. Efficient and effective monitoring involves taking readings at various points in time throughout the day, including times of peak usage ...
Get SQL Server® 2008 Administration: Instant Reference 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.
