I have a SQL Server 2014 Build(12.0.5205.0) running here.
Would It be possible to view any Live execution plan (from queries being executed by other users) in Activity Monitor ?
My problem is:
When I open the Activity Monitor - > Active Expensive Queries, I can see all expensive queries, but clicking right button the "Show Live execution Plan" is only enabled for queries that my user is running, for the any other user this menu is disabled:
An example:
I heard about Trace flags, enable a global trace flag using DBCC traceon(7412,-1).
So, my questions is:
Enabling This flag above (7412), considering the build version of my Sql Server, will it work? Or only in SQL Server 2016?
If it works, I don't have the sa rights. What kind of permissions do I have to ask for?
sys.dm_exec_query_profiles
was introduced