Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've found this link: Changes to Extended Events Permission Requirements in SQL Server 2012 that mentions the need of CONTROL SERVER permission for using extended events on SQL Server 2008. I want to grant access to extended events to developers, is not any other way to do it? We are running on SQL Server 2008R2.

share|improve this question

2 Answers 2

As Jonathan stated and the link shows CONTROL SERVER is required prior to SQL Server 2012 to create an Extended Event session. The ALTER ANY EVENT SESSION permission prior to SQL Server 2012 only allowed a user to start/stop a session, or change a current session; it will not allow them to create a session. CONTROL SERVER is required for that ability.

If this is a production system it is based on your company's policies but I would not provide a developer that level of access to anything in production. I would likely create a few different sessions that they might need for troubleshooting code in production, and then grant them ALTER ANY EVENT SESSION so they could run that as needed. They would also have the ability to then change the session as they see fit. However, be aware that even though Extended Events has less overhead than Profiler it still has overhead depending on what you are trying to capture. I would hope the developers have an understanding on what events can cause additional overhead.

share|improve this answer

Check the details in the Create an Extended Events Session Using Query Editor MSDN article. It's for SQL Server 2012, but it should be valid for 2008 too; the ALTER ANY EVENT SESSION permission should be granted.

share|improve this answer
    
That article does not apply to SQL Server 2008 R2 therefore you cannot assume it works the same way in lesser versions. In fact the only thing ALTER ANY EVENT SESSION allows in SQL Server 2008 is start/stop a session or modify a current session. It will not allow creation of an extended event session. –  Shawn Melton Aug 30 at 17:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.