When you are using the extended event to capture some data for troubleshooting purpose, you may want to start or stop it at a specific time. Unfortunately, the Extended Event feature doesn’t provide you the option to schedule it. But, it can easily be accomplished by using “ALTER EVENT SESSION” T-SQL code and SQL Server […]
Capture SQL Server Reported Errors using Extended Events
Read more
In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may make you to start playing with it. In this tip, I will be discussing how you can find what caused SQL Server to write error in the Errorlog file. Problem: One of the clients reported that […]
Extended Event Packages
Read more
I continue blogging on extended events. Today, I will discuss about the top level containers (Package) that gives access to one or more smaller items inside of extended Events Extended Event Packages Definition In the Extended Events Engine, Packages are registered inside the modules and contain the information about what Extended Events objects the module […]
Mapping SQL Trace to Extended Events
Read more
Since I started actively participating in SQL community, I found it is very common that people will approach to seek help on their SQL related issues. I do love to help people because it is always a win and win situation for both of us. Recently, I had a phone conversation with one of the […]
Extracting Deadlock information using SYSTEM_HEALTH Extended Events
Read more
Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health information of the SQL Server instance. Today, we are going to explore how quickly we can read the Deadlock information using Extended Event – “Without passing the default location of the extended events trace files” The system_health […]