United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

SQL Server Profiler Stored Procedures (Transact-SQL)

sp_trace_create (Transact-SQL)

sp_trace_generateevent (Transact-SQL)

sp_trace_setevent (Transact-SQL)

sp_trace_setfilter (Transact-SQL)

sp_trace_setstatus (Transact-SQL)

Minimize

0 out of 2 rated this helpful - Rate this topic

SQL Server Profiler Stored Procedures (Transact-SQL)

SQL Server 2008 R2

SQL Server supports the following system stored procedures that are used by SQL Server Profiler to monitor performance and activity.

sp_trace_create	sp_trace_setfilter
sp_trace_generateevent	sp_trace_setstatus
sp_trace_setevent

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

Reference

SQL Server Event Class Reference

System Stored Procedures (Transact-SQL)

Other Resources

Monitoring Events

Using SQL Trace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.