O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

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

Introduction to the Profiler

The SQL Server Profiler (pictured in Figure 4.30) is a tool that you can use to capture SQL Server events. It allows you to:

  • Diagnose bottlenecks in slow-running queries

  • Determine the cause of deadlocks or blocking

  • Troubleshoot problems between client and server applications

  • Run security audits to record login attempts

Figure 4.30. The SQL Server Profiler allows you to capture SQL Server events.

To launch the Profiler, select Tools, SQL Profiler while in Enterprise Manager, or select Profiler under the Microsoft SQL Server program group on the Start menu. To create a trace that keeps track of everything ...

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