Skip to content

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

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 SQL Server Profiler Stored Procedures (Transact-SQL)
description SQL Server Profiler stored procedures (Transact-SQL)
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
helpviewer_keywords
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
dev_langs
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