You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/tools/sql-server-profiler/start-sql-server-profiler.md
+5-28Lines changed: 5 additions & 28 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -24,49 +24,26 @@ manager: "jhubbard"
24
24
---
25
25
# Run SQL Server Profiler
26
26
You can run [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] in several different ways, to support gathering trace output in a variety of scenarios. You can start [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] from the Windows **Start** menu, from the **Tools** menu in [!INCLUDE[ssDE](../../includes/ssde-md.md)] Tuning Advisor, and from several locations in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)].
27
-
28
-
When you first start [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] and select **New Trace** from the **File** menu, the application displays a **Connect to Server** dialog box where you can specify a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] instance.
29
-
27
+
When you first start [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] and select **New Trace** from the **File** menu, the application displays a **Connect to Server** dialog box where you can specify a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] instance.
30
28
## To start SQL Server Profiler from the Windows 10 Start menu
31
-
32
29
- From the **Start** menu, browse or search for **Microsoft SQL Server Tools 2017**, and then click **SQL Server Profiler 17**.
33
-
34
30
## To start SQL Server Profiler in Database Engine Tuning Advisor
35
-
36
31
- On the [!INCLUDE[ssDE](../../includes/ssde-md.md)] Tuning Advisor **Tools** menu, click **SQL Server Profiler**.
37
-
38
32
## To start SQL Server Profiler in SQL Server Management Studio
39
33
You can start [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] from several locations in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)]. When [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] starts, it loads the connection context, trace template, and filter context of its launch point. [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] starts each profiler session in its own instance, and continues to run if you shut down [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)].
40
-
41
34
### To start SQL Server Profiler from the Tools menu
42
-
43
35
- In the [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)]**Tools** menu, click **SQL Server Profiler**.
44
-
45
36
### To start SQL Server Profiler from the Query Editor
46
-
47
-
1. On the [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] menu bar, click **New Query**.
48
-
49
-
2. In Query Editor, right-click and then select **Trace Query in SQL Server Profiler**.
50
-
37
+
- In Query Editor, right-click and then select **Trace Query in SQL Server Profiler**.
51
38
> [!NOTE]
52
39
> The connection context is the editor connection, the trace template is TSQL_SPs, and the applied filter is SPID = query window SPID.
53
-
54
40
### To start SQL Server Profiler from Activity Monitor
55
-
56
-
1. In Object Explorer, right-click an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], and then click **Activity Monitor**.
57
-
58
-
2. Click the **Processes** pane, right-click the process that you want to profile, and then click **Trace Process in SQL Server Profiler**.
59
-
41
+
- In Activity Monitor, click the **Processes** pane, right-click the process that you want to profile, and then click **Trace Process in SQL Server Profiler**.
60
42
> [!NOTE]
61
43
> 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.
62
-
63
44
## .NET Framework Security
64
-
In Windows Authentication mode, the user account that runs [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] must have permission to connect to the instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
65
-
66
-
To perform tracing with [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)], users must also have the ALTER TRACE permission.
67
-
45
+
- In Windows Authentication mode, the user account that runs [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] must have permission to connect to the instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
46
+
- To perform tracing with [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)], users must also have the ALTER TRACE permission.
68
47
## Next steps
69
48
[SQL Server Profiler overview](../../tools/sql-server-profiler/sql-server-profiler.md)
70
49
[Use SQL Server Management Studio](http://msdn.microsoft.com/library/f289e978-14ca-46ef-9e61-e1fe5fd593be)
0 commit comments