Skip to content

start-sql-server-profiler.md

Latest commit

 

History

History
71 lines (49 loc) · 4.21 KB

start-sql-server-profiler.md

File metadata and controls

71 lines (49 loc) · 4.21 KB
title Start SQL Server Profiler | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
Profiler [SQL Server Profiler], starting
SQL Server Profiler, starting
starting SQL Server Profiler
ms.assetid 22e57ffa-63b0-4de3-b92e-df297dda1226
caps.latest.revision 25
author JennieHubbard
ms.author jhubbard
manager jhubbard

Start SQL Server Profiler

You can start [!INCLUDEssSqlProfiler] in several different ways to support gathering trace output in a variety of scenarios. You can start [!INCLUDEssSqlProfiler] include from the Start menu, from the Tools menu in [!INCLUDEssDE] Tuning Advisor, and from several locations in [!INCLUDEssManStudioFull].

When you first start [!INCLUDEssSqlProfiler] and select New Trace from the File menu, the application displays a Connect to Server dialog box where you can specify the [!INCLUDEssNoVersion] 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 [!INCLUDEssCurrentUI], point to Performance Tools, and then click SQL Server Profiler.

To start SQL Server Profiler in Database Engine Tuning Advisor

  1. On the [!INCLUDEssDE] Tuning Advisor Tools menu, click SQL Server Profiler.

Starting SQL Server Profiler in Management Studio

[!INCLUDEssManStudioFull] starts each profiler session in its own instance and continues to run if you shutdown [!INCLUDEssManStudioFull].

You can start [!INCLUDEssSqlProfiler] from several locations in [!INCLUDEssManStudioFull], as illustrated in the following procedures. When [!INCLUDEssSqlProfiler] starts it loads the connection context, trace template, and filter context of its launch point.

To start SQL Server Profiler from the Tools menu

  1. In the [!INCLUDEssManStudioFull] Tools menu, click SQL Server Profiler.

To start SQL Server Profiler from the Query Editor

  1. On the [!INCLUDEssManStudioFull] menu bar, click New Query.

  2. In Query Editor, right-click and then select Trace Query in SQL Server Profiler.

    [!NOTE]
    The connection context is the editor connection, the trace template is TSQL_SPs, and the applied filter is SPID = query window SPID.

To start SQL Server Profiler from Activity Monitor

  1. In Object Explorer, right-click an instance of [!INCLUDEssNoVersion], and then click Activity Monitor.

  2. Click the Processes pane, right-click the process that you want to profile, and then click Trace Process in SQL Server Profiler.

    [!NOTE]
    When a process is selected, the connection context is the Object Explorer connection when Activity Monitor was opened. The trace template is the default based on the server type, and the SPID equals the SPID for the selected process.

.NET Framework Security

In Windows Authentication mode, the user account that runs [!INCLUDEssSqlProfiler] must have permission to connect to an instance of [!INCLUDEssNoVersion].

To perform tracing with [!INCLUDEssSqlProfiler], users must also have the ALTER TRACE permission.

See Also

SQL Server Profiler
Use SQL Server Management Studio