×

Extended Events

New Event Added to SSMS XEvent Profiler Sessions

December 3, 2019

SSMS XEvent Profiler was made available on SQL Server Management Studio (SSMS) v17.3 or later. Make sure you are using the latest version. You can find the latest version of SSMS here. What is the XEvent Profiler? The XEvent Profiler is a SQL Server Management Studio (SSMS) feature that displays a live viewer window of extended […]

Extended Event duration Millisecond or Microsecond?

July 23, 2017

There was a question in dba.stackexchange.com titled “module_end extended events duration in microseconds?” that I answered and it was Microsecond in that instance. Later on, I questioned myself if the duration is always in Microseconds for extended events. I found it is a mix of Millisecond, Microsecond and some are unknown meaning famous NULL. I […]

View Multiple System Health Extended Event Files

March 10, 2017

Last week I blogged about increasing retention of System Health session files. In this post I will show how you can open multiple files at once and work with the data as one set. If you select multiple System Health extended event files (with extension .xel) and click open each file will open in separate […]

SQL Server system_health Session Retention

March 3, 2017

As per Microsoft’s books online The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server Database Engine starts, and runs without any noticeable performance effects. The session collects system data that you can use to help troubleshoot performance issues in the […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Ready to listen to @SQLPedro talking about intelligent database.
Organized by @NESQLServer .
Hosted by @vivanovich

@BornSQL Randolph certainly is speaking to Edmonton PASS Chapter next Thursday. We had @SqlWorldWide talk to us about ... SSMS and now we get to compare Azure Data Studio to SSMS. Go to http://www.edmapss.pass.org to find out the details and register

by end of today I will be comfortable with Intelligent Query Processing feature.

Listening to @SQLBek for 2 hours ... starting at 11am.
Then hosting @SQLPedro for our UG @NESQLServer on the same topic.

Load More...