Alison Balter's Mastering Access 2002 Enterprise Development

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.

[View full size image]

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