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.
SQL SERVER – SQL Server Cluster Resource Doesn’t Come Online Randomly
This was another interesting situation where client reported that their SQL Server Cluster resource, sometimes, fail to come online when they perform failover of SQL Server from one node to another. In this blog, we would learn how to fix ” SQL Server resource not coming to an online state ” issue.
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?