Terms you’ll need to understand:
✓ System Monitor
✓ Database Engine Tuning Advisor (DTA)
✓ Activity Monitor
✓ Trace flag
✓ Database console command (
✓ Dynamic management view
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 ...