We’ll go through the steps to set up an Extended Events session, run a sample stored procedure, and then query the captured data.
SQL SERVER – List of Trace Events
I posted a blog post SQL SERVER – Identify Table Creation Date from Traces. Let us see how to see all the list of trace events.
SQL SERVER – Identify Table Creation Date from Traces
I often discuss this during Comprehensive Database Performance Health Check. Let us learn about how to Identify Table Creation Date from Traces.
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 – xp_create_subdir() Returned Error 183, ‘Cannot Create a File When that File Already Exists
New client, new idea and a new blog! That’s how I have been writing a daily blog for many years now. In this blog, I would share my learning from a client who faced error “xp_create_subdir() returned error 183, ‘Cannot create a file when that file already exists” while running maintenance plan.
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
One of my clients contacted me to resolve an issue where they were seeing these errors few minutes after restarting SQL Server Service. In this blog, we would learn about how to fix error Timeout occurred while waiting for latch: class FGCB_ADD_REMOVE.
SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events
In this blog post with the help of Extended Events, we will learn how to identify all the deprecated SQL Server Features. This feature can be very much handy when we are changing the compatibility of SQL Server and we want to check what are all the deprecated SQL Server features we are still using in our active code.