All of the data generated by an event is displayed in the trace in a single row. This row is intersected by data columns that describe the event in detail.
An event class is a type of event that can be traced. The event class contains all of the data that can be reported by an event. The following are examples of event classes:. For example, all lock events classes are grouped within the Locks event category. This term doesn't reflect the way Engine events are grouped. A data column is an attribute of an event class captured in the trace.
Because the event class determines the type of data that can be collected, not all data columns are applicable to all event classes. For example, in a trace that captures the Lock: Acquired event class, the BinaryData data column contains the value of the locked page ID or row, but the Integer Data data column doesn't contain any value because it isn't applicable to the event class being captured.
A template defines the default configuration for a trace. For example, you can create a template that specifies the events, data columns, and filters to use. A template isn't executed, but rather is saved as a file with a. Once saved, the template controls the trace data that is captured when a trace based on the template is launched. A trace captures data based on selected event classes, data columns, and filters. Select Language:. Choose the download you want.
Download Summary:. Total Size: 0. Back Next. Microsoft recommends you install a download manager. Microsoft Download Manager. Manage all your internet downloads with this easy-to-use manager.
It features a simple interface with many customizable options:. Download multiple files at one time Download large files quickly and reliably Suspend active downloads and resume downloads that have failed. Yes, install Microsoft Download Manager recommended No, thanks. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Note, you can use the same steps or selection of event classes for any version of SQL Profiler.
Tiny SQL Profiler is a free replacement tool for Microsoft SQL Profiler, it allows you to view queries made against SQL Server database in real time using sophisticated arsenal of filters, making it easier to debug and diagnose database applications. But how is written three answer before:. Probably all that you need.
0コメント