It's just Emanuele showing you what you can do in the Microsoft Data Platform

Tagextended events

There’s a Bug with Extended Events creation in SQL Server Management Studio 18.7: what it is and a workaround

By Emanuele Meazzo
In Tips&Tricks
October 26, 2020
1 Min read
T

UPDATE: The bug still isn’t fixed in SSMS 18.7.1 Oh boy, what I found; I haven’t seen anybody else reporting on it, yet, so here I am.Fortunately, the bug is not breaking, as I’ve found a workaround, but still. Repro Open the “New Session…” GUI for extended events in SSMSGive it a name, it’s not importantAdd an event with a Duration Field, I’ve...

Read onRead later1 comment

How to identify the unit of measure of Extended Events durations

By Emanuele Meazzo
In Tips&Tricks, Troubleshooting
April 10, 2019
1 Min read
H

Even if I use Extended Events almost every day, I always forget the unit of measure of each duration counter, since they’re basically arbitrary; Seconds, milliseconds, microseconds? Whatever, it depends on the dev that implemented that specific counter. That’s why I’ve added to Tsql.tech Github repository the following code that extracts the descriptions from XE DMVs in order to...

Read onRead later2 comments
It's just Emanuele showing you what you can do in the Microsoft Data Platform

Emanuele Meazzo

My Social Profiles

If you're interested in following me around in the social world, here are some URLs for you