View transaction related events in a SQL Server Profiler trace

When we open SQL Server Profiler to start a new trace transaction related events are not visible by default in the ‘Events Selection’ tab…

BUT… if we check the ‘Show all events‘ checkbox close to the bottom right and then stroll near to the end we’ll see a Transactions section which we can expand to select transaction related events we are interested in…

Leave a Reply

Your email address will not be published. Required fields are marked *