When it comes to monitoring and troubleshooting SQL Server performance, two commonly discussed tools are SQL Profiler and Extended Events (XEvents). While both serve the purpose of capturing events ...
- "extended events [SQL Server], system health session" - "extended events [SQL Server], system_health session" - "system_health session [SQL Server extended events]" - "system health session [SQL ...
One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...
Query Store is a feature introduced in SQL Server 2016 that acts as a flight recorder for your database queries. It automatically captures a history of queries, plans, and runtime statistics, and ...
The much-used Microsoft SQL Profiler is a tool headed toward obsolescence. What options are available once the tool is deprecated? We examine SQL Server Extended Events as a possibility. The ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results