What is SQL Trace?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is SQL Trace?
Rating:
SQL Trace is used to create traces by using stored procedures. These traces gather events, which are instances of event classes. These events can be filtered out of the trace and stored in a file or SQL Server Management Objects (SMOs).
The following stored procedures are used to create and manage traces:
| sp_trace_create | It creates a trace. |
| sp_trace_setevent | It adds or removes event classes. |
| sp_trace_setfilter | It applies a new or modified filter to a trace. |
| sp_trace_setstatus | It starts, stops, or closes a trace. |
| sp_trace_generateevent | It creates a user defined event. |
| fn_trace_geteventinfo | It returns information about the events included in a trace. |
| fn_trace_getinfo | It returns information about a specified trace or all the existing traces. |
| fn_trace_getfilterinfo | It returns information about filters applied to a trace. |
Rating:
Was this information helpful?
Other articles
- What is the REPEATABLE READ isolation level?
- What is the Log Reader agent?
- What is a partitioned index?
- What is a restore job?
- What is index fragmentation?