Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler. Image is taken from here An ancient, dark place, a source of many legends and histories, although some people have been able to get out alive, some others are stuck there, the locals refer to it as "The nosy one" but we know it for another name: SQL Server Profiler SQL Server introduced Extended Events since 2008 version, and was meant to replace SQL Server profiler traces (that will be deprecated in the near future), and provides a lightweight, customizable event collection platform, and you should be using it now. What is an Extended Event? According to Microsoft official documentation, is a highly scalable and configurable architecture to be able to identify and troubleshoot any performance issue, it consists of: Packages: Contains the required objects to collect and process data. Sessions: Process to be executed to collect the data Events: Info to be collected and later analyzed. Actions: Fields common to a