O'Reilly logo

MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 by Thomas Moore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required