SQL Server Profiler Stored Procedures (Transact-SQL)
SQL Server supports the following system stored procedures that are used by SQL Server Profiler to monitor performance and activity.
For an example of using trace stored procedures, see Create a Trace (Transact-SQL).