XESmartTarget

Welcome to the first recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the xesmarttarget tag on this blog. Recipes: what are the ingredients? Every recipe starts with a problem to solve and has three ingredients: A session to capture the eventsA JSON configuration file for XESmartTarget to process the eventsA client application to read the data produced by XESmartTarget The problem In this case, imagine that you wanted to observe the commands executed on a SQL Server instance and save them to a file to process them later. [Read More]

Some time ago, I started a project called XESmartTarget. I find it super useful and you should probably know about it. It’s totally my fault if you’re not using it and I apologize for all the pain that it could have saved you, but it didn’t because I did not promote it enough. Now I want to remedy my mistake with a 10 days series of blog posts on XESmartTarget, which will show you how useful it can be and how it can be used to accomplish your daily DBA tasks using Extended Events. [Read More]