Chapter 7. Monitoring SQL Server Performance

Terms you’ll need to understand:

  • ✓ System Monitor

  • ✓ Database Engine Tuning Advisor (DTA)

  • ✓ Profiler

  • ✓ Activity Monitor

  • ✓ Trace flag

  • ✓ Database console command (DBCC)

  • ✓ Statistics

  • ✓ Workload

  • ✓ Dynamic management view

  • ✓ Baseline

Techniques you’ll need to master:

  • ✓ Using tools to monitor performance

  • ✓ Generating workload for DTA

  • ✓ Recording activity over time

This chapter investigates the tools that are provided with SQL Server to inspect and record activity in an installation. With the information gathered you can then attempt to provide for an optimal database and application environment. Several of these tools ship with SQL Server, and some are built in to the Windows operating system.

SQL Server Management Studio ...

Get MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 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.

Start your free trial