Skip to content

sql-server-profiler-templates-and-permissions.md

Latest commit

 

History

History
60 lines (44 loc) · 4.85 KB

sql-server-profiler-templates-and-permissions.md

File metadata and controls

60 lines (44 loc) · 4.85 KB
title SQL Server Profiler Templates and Permissions
titleSuffix SQL Server Profiler
description Learn how SQL Server Profiler works, how to use it to trace events, and where to find more information on its features.
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology profiler
ms.topic conceptual
ms.assetid 6d00378a-5d74-463b-9ed6-a2685306a9d2
author markingmyname
ms.author maghan
ms.custom seo-lt-2019
ms.date 03/14/2017

SQL Server Profiler Templates and Permissions

[!INCLUDE SQL Server]

[!INCLUDEssSqlProfiler] shows how [!INCLUDEssNoVersion] resolves queries internally. This allows administrators to see exactly what [!INCLUDEtsql] statements or Multi-Dimensional Expressions are submitted to the server and how the server accesses the database or cube to return result sets.

Using [!INCLUDEssSqlProfiler], you can do the following:

  • Create a trace that is based on a reusable template

  • Watch the trace results as the trace runs

  • Store the trace results in a table

  • Start, stop, pause, and modify the trace results as necessary

  • Replay the trace results

Use [!INCLUDEssSqlProfiler] to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process, and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.

Note

Trace column values greater than 1 GB return an error and are truncated in the trace output.

In This Section

Topic Description
SQL Server Profiler Templates Contains information about the predefined trace templates that ship with [!INCLUDEssSqlProfiler].
Permissions Required to Run SQL Server Profiler Contains information about the permissions that are required to run [!INCLUDEssSqlProfiler].
Save Traces and Trace Templates Contains information about saving trace output and about saving trace definitions into a template.
Modify Trace Templates Contains information about modifying trace templates by using [!INCLUDEssSqlProfiler] or by using [!INCLUDEtsql].
Start a Trace Contains information about what happens when you start, pause, or stop a trace.
Correlate a Trace with Windows Performance Log Data Contains information about correlating Windows performance log data with a trace by using [!INCLUDEssNoVersion] Profiler.
View and Analyze Traces with SQL Server Profiler Contains information about using traces to troubleshoot data, displaying object names in a trace, and finding events in a trace.
Analyze Deadlocks with SQL Server Profiler Contains information about using [!INCLUDEssSqlProfiler] to identify the cause of a deadlock.
Analyze Queries with SHOWPLAN Results in SQL Server Profiler Contains information about using [!INCLUDEssSqlProfiler] to collect and display Showplan and Showplan Statistics results.
Filter Traces with SQL Server Profiler Contains information about setting filters on data columns to filter trace output by using [!INCLUDEssSqlProfiler].
Replay Traces Contains information that explains what replaying a trace means and what is required to replay a trace.

See Also

SQL Server Profiler
Start SQL Server Profiler