Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

XEvent Profiler in SSMS: Real-Time SQL Server Monitoring

Published by

Rajeev Pentyala

on

Let’s say you’re a SQL Server Administrator and you want to track who is running queries or executing stored procedures on your server.

The XEvent Profiler in SQL Server Management Studio (SSMS) enables quick access to a live streaming view of diagnostics events on the SQL Server.

This view can be customized and those customizations can be shared with other SSMS users as a .viewsettings file.

Prerequisites

This feature is only available on SQL Server Management Studio (SSMS) v17.3 or later. Make sure you are using the latest version. You can find the latest version here.

Please refer to the official Microsoft documentation: Getting Started with XEvent Profiler

🙂

Advertisements
Advertisements

Leave a comment

Visitors

2,075,581 hits

Top Posts
[Step by Step] Beginner : Create a PCF control and add it to a custom page[Step by Step] Beginner : Create a PCF control and add it to a custom pageDecember 2, 2024Rajeev Pentyala
Direct Line API + Copilot Studio Agent: Build a C# Console Messaging AppDirect Line API + Copilot Studio Agent: Build a C# Console Messaging AppNovember 5, 2025Rajeev Pentyala
[Step by Step] Configure and consume 'Environment Variables' of type 'Secret' using 'Azure Key vault'[Step by Step] Configure and consume 'Environment Variables' of type 'Secret' using 'Azure Key vault'May 2, 2023Rajeev Pentyala