SQL Extended Events Archives - Page 3 of 4 - SQL Authority with Pinal Dave

SQL SERVER – XEvents to Find Cardinality Estimation Issues

December 2, 2015

Ever since SQL Server 2014 brought the new Cardinality estimates, there have been a number of blogs to talk about them. Even here, I wrote a quite a few blogs about this very subject. SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation SQL SERVER –…

SQL SERVER – To Find Events Mapped to Channels in Extended Events

October 13, 2015

Pinal Dave

SQL Tips and Tricks

SQL Extended Events, SQL Scripts, SQL Server

I have outlined a number of blogs here that point to the basics of working with Extended Events. Some of them also detail you some specific scenarios that you can use inside your environments.

SQL Server – Knowing Deprecated or Discontinued Features Using Extended Events

May 23, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events

This blog is in continuation to what I wrote couple of weeks back – SQL Server – Knowing the Use of Deprecated or Discontinued Features. The concept of using a deprecated feature is not by intensions by developers but is an accident for many. When I wrote that blog post, lesser…

SQL SERVER – Identify Page Splits Using Extended Events in SQL Server

May 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events

Digging some of my older posts reveal I have written a blog already on Page Splits with SQL Server. This was no surprise because I am in constant need to reinvent as I write the blog posts. Now you might ask, why was I searching. Well, when I was talking…

SQL SERVER – System procedures to know SQL Server Version

March 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events, SQL Stored Procedure

There are several ways to know the version of SQL Server. But did you know that there are two system procedures through which you can know the version? They are SP_SERVER_INFO and EXEC XP_MSVER EXEC sp_SERVER_INFO If you execute the above, you get a result set with informations about the…

SQL SERVER – Filtering CPU Bound Execution Plans with Extended Events

November 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL CPU, SQL Extended Events

Let me take a tour to what are we talking here from a scenario point of view. Prior to SQL Server 2012, tracing the execution plan is an all or nothing approach. In profiler, if we select execution plan, we will get every occurrence of every execution plan for all…

SQL SERVER – Idera SQL XEvent Profiler – a Free Tool for XEvent Monitoring

April 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Idera, SQL Extended Events

Download Extended Event Profile FREE We often resist the change, we do not like change and we keep on using the same old technology which we have been using it to resolve the new challenges which we face in our daily life. The Extended Event is such a technology as…