Enable developers to run SQL trace in DEV environment without the sysadmin role

This post was formerly published at my beloved old blog "On the quest of a DBA's adventure......"

My developers have asked me to enable them to run SQL Server Profiler on their DEV instance. To enable them to do their job, I am along with them to give them the ability to diagnose their issue.

In the past, before SQL Server 2005, one would need sysadmin role to run trace with SQL Server Profiler. Microsoft does listen to user and realise that developers are more likely need the ability to diagnose issue that they created and DBAs are the busy breed which are too busy to just sit there and run a trace with a developer now and then. So, they make the premission requirement more granular, and this is how to give someone permission to run SQL Server Profile without sysadmin role:

This helps to make friends between DBA team and developers. NICE!! Thanks to Microsoft.

Reference
Permissions Required to Run SQL Server Profiler
From MSSQLtips.com - How to Grant Permissions to run SQL Server Profiler for a non System Admin User