Skip to content

Latest commit

 

History

History
47 lines (38 loc) · 1.71 KB

sql-server-profiler-stored-procedures-transact-sql.md

File metadata and controls

47 lines (38 loc) · 1.71 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords dev_langs
SQL Server Profiler stored procedures (Transact-SQL)
SQL Server Profiler stored procedures (Transact-SQL)
markingmyname
maghan
randolphwest
08/22/2024
sql
system-objects
reference
system stored procedures [SQL Server], SQL Server Profiler
Profiler [SQL Server Profiler], stored procedures
SQL Server Profiler, stored procedures
monitoring performance [SQL Server], stored procedures
performance [SQL Server], stored procedures
TSQL

SQL Server Profiler stored procedures (Transact-SQL)

[!INCLUDE SQL Server]

[!INCLUDE ssNoVersion] supports the following system stored procedures that are used by [!INCLUDE ssSqlProfiler] to monitor performance and activity.

:::row::: :::column::: sp_trace_create

    [sp_trace_generateevent](sp-trace-generateevent-transact-sql.md)

    [sp_trace_setevent](sp-trace-setevent-transact-sql.md)
:::column-end:::
:::column:::
    [sp_trace_setfilter](sp-trace-setfilter-transact-sql.md)

    [sp_trace_setstatus](sp-trace-setstatus-transact-sql.md)
:::column-end:::

:::row-end:::

For an example of using trace stored procedures, see Create a Trace.

Related content