I have created an extended events session in which I wanted to see all queries using nolock hint. Instead of sql trace I have decided to use extended events session to minimaze possible performance impact. Session was created like with following statement:

I have created an extended events session in which I wanted to see all queries using nolock hint. I have decided to use it instead of sql trace in order to minimaze possible performance impact. Session was created like with following statement: