O'Reilly logo

Mastering SQL Server® 2008 by Gentry Bieker, Michael Lee

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

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