Skip to content

Latest commit

 

History

History
50 lines (41 loc) · 2.28 KB

File metadata and controls

50 lines (41 loc) · 2.28 KB
description SQL Server Profiler Stored Procedures (Transact-SQL)
title SQL Server Profiler Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology system-objects
ms.topic reference
dev_langs
TSQL
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
ms.assetid 8c99c3db-0b04-46c3-aa59-d6f680522fdd
author markingmyname
ms.author maghan

SQL Server Profiler Stored Procedures (Transact-SQL)

[!INCLUDE SQL Server]

[!INCLUDEssNoVersion] supports the following system stored procedures that are used by [!INCLUDEssSqlProfiler] to monitor performance and activity.

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

    [sp_trace_generateevent](../../relational-databases/system-stored-procedures/sp-trace-generateevent-transact-sql.md)

    [sp_trace_setevent](../../relational-databases/system-stored-procedures/sp-trace-setevent-transact-sql.md)
:::column-end:::
:::column:::
    [sp_trace_setfilter](../../relational-databases/system-stored-procedures/sp-trace-setfilter-transact-sql.md)

    [sp_trace_setstatus](../../relational-databases/system-stored-procedures/sp-trace-setstatus-transact-sql.md)
:::column-end:::

:::row-end:::

For an example of using trace stored procedures, see Create a Trace (Transact-SQL).

See Also

SQL Server Event Class Reference
SQL Trace
System Stored Procedures (Transact-SQL)