Using EVENT SESSION functionality (available from Q4 2025)

This module is a supplementary performance monitoring module for Microsoft SQL Server. It leverages the native Extended Events (XEvent) session functionality
to collect detailed execution statistics. The module can be used on its own, but is primarily designed to complement the existing SQL Performance module in dbWatch.

In the SQL Performance module, a job named SQL Statistics captures snapshots of performance data for cached SQL query plans by reading from system dynamic management views such as
sys.dm_exec_query_stats, sys.dm_exec_sql_text, and sys.dm_exec_text_query_plan.

In contrast, the Session SQL Event Collector installs a job named Session SQL Event Collector that gathers performance statistics directly from the dbWatchSessionStatsXE Extended
Events session. This approach captures long-running SQL batches and RPC calls, along with contextual information such as session, client, and database details.

By combining the two jobs, dbWatch provides both a system-level overview of cached plans and user-level visibility into who is executing what. This gives database administrators a
more complete picture of workload patterns and performance bottlenecks.

In the Management section of dbWatch, the collected data is presented and structured in a similar way as in the SQL Performance module. When the Session SQL Event Collector job is
installed, a new entry named SQL session event will appear in the tree view, directly under SQL performance.

This entry provides access to the statistics gathered from the Extended Events session, displayed in a familiar layout for easy comparison and combined analysis. The structure
ensures consistency across modules, so DBAs can seamlessly navigate between cached plan statistics from the SQL Performance module and session event statistics from the Session SQL Event Collector.

Example main view: