×

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

Lightning Talks! We had them the last time and they are back. We have 10 speakers lined up to cram as much content as ... possible into a 10-minute slot. Find out more at http://www.dataweekender.com and sign up.

SSMS 18.9 had a bug. Fix is out with 18.9.1
... https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

SQLServerGeeks is conducting a Virtual Symposium on SQL Server and Azure SQL.
Learn from skilled data professionals and... gather critical knowledge on all things SQL.

http://bit.ly/ssg_vs_may_2021

#SQLServer #SQL #AzureSQL @feaselkl @EdwardPollack
@rob_rich @i619619 @dbafromthecold

Calling all SQL database administrators, this session is for you! SQL is everywhere you need it from the IoT Edge to ... your datacenter to public clouds. Learn about these options, which to choose, and why with @BobWardMS on April 28. Register: https://bit.ly/3dffR9z #AzureSQL

Load More...