Recently, I gave my first presentation of the year at Austin .NET User Group on Writing Faster Queries and I got a great question about Extended Events. The question was, “What security permissions are required for creating and modifying Extended Event Sessions?” I thought it would make a great blog post as I am sure others might be wondering the same thing.
In SQL Server 2008 to create an Extended Event Session you are going to need CONTROL SERVER and ALTER ANY EVENT SESSION permission on the instance that you need Extended Events created on. With SQL Server 2012 and 2014 If you want to create and modify Extended Events you are only going to need ALTER ANY EVENT SESSION.
If you like this post check out these other related blog posts: