Questions tagged [showplan]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
34 views

SSMS 2014 does not launch Graphical Execution Plan from clicking hyper-linked query plan - ShowPlanXML

I am working with an older version of Microsoft SQL Server Management Studio 2014. I run the following query: SELECT TOP 10 Q.* FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_query_plan( qs....
1
vote
1answer
377 views

Who has SHOWPLAN permissions on a database

Is there a way I can see all users in a database who currently have access to view execution plans? That is, who has SHOWPLAN permissions
2
votes
1answer
200 views

SQL Profiler plus Include Actual Execution Plan

Is there any option to show "Include Actual Execution Plan" plus query cost and recommended indexes in SQL Profiler? I see Showplan XML, but it shows only the execution plan without recommended ...
3
votes
1answer
3k views

What are SHOWPLAN permission security risks? (MS SQL Server)

I'm having some friction when it comes to showplan permission security. Say there are 5 databases on a server. And each one has a test/ production split (so 10 total). There is one sysadmin. There ...