Performance Overhead
Last updated
Was this helpful?
3.0
Last updated
Was this helpful?
SQLWATCH is designed with minimum overhead. It utilises where possible and collectors that run every minute by default.
SQL Server The Extended Events architecture enables users to collect as much or as little data as is necessary to troubleshoot or identify a performance problem. Extended Events is configurable, and it scales very well.
The frequent data collectors such as performance run every minute and take less than a second to execute. There are areas for improvement in the way the XML output from XE sessions is being parsed which will be addressed in the future releases.
The below screenshot shows a 60 seconds window of CPU utilisation of the sqlservr.exe process. The spike is the performance collection which lasts few milliseconds:
