Andreas Wolter 8/14/2013

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

Read Original

This technical article presents a detailed benchmark analysis of the performance overhead imposed by SQL Server Extended Events and traditional SQL Trace, specifically under conditions of high CPU load. It compares the core tracing mechanisms, various Extended Event targets, and includes tests with no target to isolate the overhead of the tracing technology itself.

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

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week