Submit Blog

Sign up Sign in

Search Articles

Filter by Tag

Sort By

Popular Tags

SQL Trace Articles

Page 1 of 1 (2 articles)

Performance overhead of tracing with Extended Event targets vs SQL Trace under CPU Load

8/14/2013 • EN

Performance overhead of tracing with Extended Event targets vs SQL Trace under CPU Load

Benchmarks comparing the CPU performance overhead of SQL Server Extended Events vs. SQL Trace under high CPU load.

benchmarking Extended Events performance SQL Server SQL Trace

Extended Event File Target size vs SQL Server Trace trace file – a comparison

6/9/2013 • EN

Extended Event File Target size vs SQL Server Trace trace file – a comparison

Compares file sizes between SQL Server Extended Events and deprecated SQL Trace, finding XML format adds ~29% overhead.

Database Administration Extended Events performance monitoring SQL Server SQL Trace