Query profiler

The Query Profiler in the MSSQL extension for Visual Studio Code captures and monitors

database activity in real time using

Extended Events. You can observe live T-SQL activity, identify

slow operations, and find performance bottlenecks during development.

Query Profiler supports SQL Server (on-premises or in cloud environments), Azure SQL Database,

and SQL database in Fabric endpoints. You can monitor active sessions, review execution details,

and understand how your application interacts with your database during development and

testing.

Query Profiler in the MSSQL extension provides the following capabilities:

Capture real-time query and database activity in a live events grid.

Configure new profiling sessions with template selection and session naming.

Control the session lifecycle with

,

,

,

, and

actions.

Run multiple concurrent profiling sessions and switch between them with the session

selector.

Filter captured events by text, database name, duration, and other fields.

