This template monitors the IO for database log files on a server by tracking asynchronous IO, database log flushes, file writes, spinlock backoffs of type LOGFLUSHQ and waits of type WRITELOG. This template collects data in two ways: raw data is collected to a ring buffer and spinlock backoff information is aggregated based on the input buffer (sql_text). The session is filtered for a single log file per database; if you have multiple log files you can modify the filter for the file_write_completed and file_written events to include more than just file_id = 2.
This template collects detailed statement and error information. You can use this template to track each statement that has ...
This template counts the number of locks acquired by each query based on the query_hash value. You can use this template ...
This template is similar to the 'Default Trace' that exists in the SQL Trace system. Use this template to track general activity ...
This template is to collect batch level SQL statements and user login information. Events to be collected in this template ...
This template monitors the IO for database log files on a server by tracking asynchronous IO, database log flushes, file ...
This template records information required to replay the trace. Use this template to perform iterative tuning, such as benchmark ...
This template tracks connection activity for a server. Normal connection activity is tracked using the login and logout events, ...
This template tracks internal and external wait statistics for individual query statements, batches and RPCs. This template ...
This timer job triggers the background processing operations for the SQL Server Reporting Services Service Application it ...