Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler

Moved from: bobsql.com
 
I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and event_sequence processing I thought others might find helpful. – Enjoy!
 

The sample code is provided “as is” a… Continue reading Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler

SQL Mysteries: Causality tracking vs Event Sequence for XEvent Sessions

Moved from: bobsql.com
 
You need to make sure to order the events by event_sequence when doing analytics on the XEvent data. It has been proposed to me that you can use the causality tracking sequence as a sort target, which may work as long as y… Continue reading SQL Mysteries: Causality tracking vs Event Sequence for XEvent Sessions

The loghttp module in the worker process with id ‘xxxx’ could not obtain custom log data for ‘1’ req

Recently we worked on an issue where if we set “Both log file and ETW event” for Log Event Destination in the IIS logging, we would see the below error in the event logs for each and every request:
 
Log Name:      Applica… Continue reading The loghttp module in the worker process with id ‘xxxx’ could not obtain custom log data for ‘1’ req

App Service Environment (ASE) V3 Key Vault Reference behavior

As we know, the Azure App Service/Function App support to use the Key Vault Reference (Use Key Vault references – Azure App Service | Microsoft Docs), and customer can use this setting to read the App Service Settings from the Key Vault directly wit… Continue reading App Service Environment (ASE) V3 Key Vault Reference behavior