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
🙂
Leave a Reply