Starting SQL Server Profiler

  • Article

You can start SQL Server Profiler in several different ways to support gathering trace output in a variety of scenarios. The different ways to start SQL Server Profiler include: from the Start menu, from the Tools menu in SQL Server Management Studio, and from the Tools menu in Database Engine Tuning Advisor.

When you first start SQL Server Profiler and select New Trace from the File menu, the application displays a Connect to Server dialog box where you can specify the SQL Server instance to which you want to connect.

To start SQL Server Profiler from the Start menu

  1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Performance Tools, and then click SQL Server Profiler.

To start SQL Server Profiler in SQL Server Management Studio

  1. On the SQL Server Management Studio Tools menu, click SQL Server Profiler.

To start SQL Server Profiler in Database Engine Tuning Advisor

  1. On the Database Engine Tuning Advisor Tools menu, click SQL Server Profiler.

Security

In Windows Authentication mode, the user account that runs SQL Server Profiler must have permission to connect to an instance of SQL Server.

To perform tracing with SQL Server Profiler, users must also have the ALTER TRACE permission.

See Also

Other Resources

Introducing SQL Server Profiler
Tuning the Physical Database Design
Introducing SQL Server Management Studio

Help and Information

Getting SQL Server 2005 Assistance