To make extended events work, you need to set up a session. Chapter 6, “What Is Extended Events?”, covered the parts and pieces that comprise a session. Chapter 7, “Implementing Extended Events via the GUI,” covered how to set up a session in the GUI. In this chapter, you will learn how to set up an extended event session with SQL scripts.
Just because you can audit everything, doesn’t mean that you should. If you audit everything and anything, you will ...