one of the first things which I check is if any specific trace flag is enabled on the server or not. Let us learn how we can do that with TRACESTATUS.
Capture Query Plans Using Extended Events and Traces – Analyzing SQL Server Query Plans – Part 1
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Capture Query Plans Using Extended Events and Traces.
How to Find Running SQL Trace? – Interview Question of the Week #123
Question: How to Find Running SQL Trace? Once we know the trace exists, how to stop and delete them?