Extended events has firmly established itself as the premier diagnostic feature in SQL Server and SQL Server 2016 brings along more events to correspond to
UPDATE: Last month (Sept 2015), Extended Events (not just the metadata that I wrote about) are officially available in Azure SQL Database!! For more information,
I’ve been doing some investigation of the new cardinality estimator in SQL Server 2014. I’ve always thought the best way to see how the estimation
About a month ago, I wrote a series of blog entries on the Selective XML Index introduced in SQL Server 2008 SP1. Just to summarize
I’ve been looking a bit more into the SQL Server 2012 SP1 release, mostly to find diagnostics related to the Selective XML Index (SXI). I
I've heard it said that the main difference between SQL Server Extended Events and SQL Server Event Notifications is that you can't "react to" Extended
Continued from the previous post, "Some new/upcoming Windows Azure SQL Database DMVs and diagnostics"… Read that one to find out who Vinod and Michal are.
A variation of this question came up a few weeks ago on a mail list that I subscribe to and it seems to come up a
I've said before how thrilled I am will the new extended event UI in SSMS for SQL Server 2012. However, you might be one of
Last week, while teaching a class based around SQL Server 2008 R2, I happened to "brag up" the new tools in SQL Server 2012, mainly
I'm not usually one for repeating stuff you can find in BOL. Usually, a waste of your time and mine. But this feature, for SQL
I've been looking at the Extended Event library and PowerShell provider "directory" in Denali and decided that I like it. It's a traditional SMO set
I've been going through the XEvents in Denali CTP1 in a fairly rigorous amount of detail, looking for what's changed and specifically for breaking changes.
Just having a look at PowerShell support in SQL Server Denali CTP1. In Denali you must install PowerShell V2 or it will be installed as
I've been doing talks and demos on SQL Server 2008 Extended Events for a while now, it's one of my favorite parts of the product.
One of my favorite new features of SQL Server 2008 is extended events. I've written a bunch of blog entries on 'em (use the search,
It's easier than you'd think… When you use the SQL Server 2008 CREATE EVENT SESSION DDL statement with extended events, you specify: Events to be
Last blog entry on SQL Server Extended Events for a while. But…a couple of questions came up since I wrote my first blog entry on
This won't be as long of an entry because I'm trying to finish describing the items that you can use in an XEvent session, that
It's another rainy day in Portland in summer, so I thought I'd stay inside and write more about SQL Server 2008 Extended Events. I wanted
It's summertime in Oregon and its been nice and warm out (75-85F) lately. But today its raining (or specifically, the skies are quite ominous right now),
When starting out with XEvent support, I thought it would be good to start with the ETW target, although you can capture and catagorize events
When I'm doing problem solving, its always good to have too much information rather than too little. With this in mind, I was quite interested
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.