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 […]
Introduction to Extended Events
Read more
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in SQL Server 2008, and it provides a very rich method of collecting diagnostic data from SQL Server. You can get in-depth detailed information using extend event for troubleshooting which was never possible with SQL Trace. […]