Nine pre-created templates are available with the SQL server 2009.
But, between instances of different SQL Versions, the templates cannot be imported. Between the same instances of SQL server, the templates can be exported, imported and saved. Template: Trace's default configuration is defined as template. These traces are normally stored in the trace files and also in the database. Trace: Capturing the data depending on the filters, event classes and data columns that are selected is called as Trace. The event class values are present in the data column. Any number of categories can be used, even if there is only one trace.Įxamples for event category : Locks and stored procedures.ĭata Column: An event class attribute that has been captured in the trace is called as data column. The various terminologies used in the SQL server Profiler are event, event class, event category, trace, data column, template and filter.Įvent: Within the instance of Database Engine of SQL Server, there is an action and this is termed as an event.Įxamples for Event : Creating the jobs, Running the stored procedures, Running the T-SQL scripts and performing operations in the SSMS.Įvent Class: Event type which can be traced is defined as the event class.Įxamples for Event Class : RPC : Completed and SP : StartingĮvent Category: Event category are defined as the group of events. But before that, it is necessary that one should know the terminologies used in order to learn the working of the Profiler without much difficulty. Now, We are ready to learn how the SQL server Profiler works. Terminologies used in the SQL Server Profiler
The trace becomes huge since it has all the T-SQL scripts that are running on the server In order to avoid this condition, it is better to consider only the data that is needed for the analysis. Various T-SQL scripts that are running simultaneously in the SQL server are included in the trace.
0 kommentar(er)
