Chapter 10

Monitoring SQL Server Activity

As a database administrator, you need to understand the options available for monitoring your SQL Servers. Knowing where to look will help you isolate performance issues. This chapter focuses on the tools available for monitoring different aspects of a SQL Server. We'll begin by monitoring system performance as a whole, and then we'll move into more specific methods of watching activity and patterns in SQL Server. In this chapter, you will learn to:

  • Use System Monitor to identify performance bottlenecks
  • Use Profiler and design appropriate traces to monitor events on SQL Server
  • Build DDL (Data Definition Language) triggers
  • Use event notifications to asynchronously capture events occurring on your SQL ...

Get Mastering SQL Server® 2008 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.