Questions tagged [showplan]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
309 views

Is it possible to edit the “Missing Index Details” template in SSMS?

When you turn on "Include Actual Execution Plan" and run a query in SSMS, the resultant plan can include information about missing index(es) that would make the query more performant. In that case, ...
0
votes
1answer
263 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....
2
votes
1answer
1k 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
415 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
6k 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 ...