All Questions
Tagged with ssms execution-plan
22
questions
0
votes
1
answer
27
views
SQL Server management Studio does not show Index recommendation
I have installed SQL Server management studio version 20 (and also tried with 19 and 18) and surprisingly unable to see the Missing Index Hints while explaining a SQL Query. Whenever i receive a SQL ...
5
votes
3
answers
536
views
Hovering over an Operator in Execution Plans: How to make the tooltip not disappear when moving the mouse
I want to share my screen and show an execution plan but when I hover my mouse over an operator and what to point to something with my mouse in the tooltip then it disappears. Is there a way to make a ...
0
votes
1
answer
339
views
Actual Execution plan does not have memory grant info
I manually ran query in SSMS and captured actual execution plan of the query by enabling its icon in SSMS. I am not getting "Memory Grant" when I keep my mouse on SELECT OPERATOR. I didn't ...
0
votes
1
answer
853
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
1
answer
460
views
Graphical Actual Execution Plan - Estimated vs Actual number of rows
I am using:
SQL Server Management Studio v18.1
SQL Server 2017 CU9
AdventureWorks restored from here
Test query:
USE [AdventureWorks];
GO
SELECT TOP (13) *
FROM Sales.SalesOrderHeader AS s
...
4
votes
1
answer
367
views
Search SQL Server Execution Plan by cost in SSMS
I was given a large Execution plan and I'm trying to find the nodes connected to high costs. SSMS offers a search util, however, I did not find the option that searches for the cost value in percent.
...
1
vote
0
answers
899
views
Converting show-plan XML to graphical view plan
I am using the performance dashboard to set up baseline monitoring for my inventory of SQL servers. As per the performance dashboard available within SSMS, when i click on any query to view the plan ...
6
votes
1
answer
939
views
Execution plan doesn't show memory grant
I installed SQL Server 2019 on a VM on Azure (DS11). I am trying to illustrate adaptive query processing using this post here. The issue is that when I hit CTRL+L in SQL Server Management Studio to ...
4
votes
1
answer
293
views
Reading 300% rows - Problematic execution plan
Whole queryplan and query: https://www.brentozar.com/pastetheplan/?id=BkgbANxN4
I am struggling with a query that uses a lot of time.
The obvious reason for this is wrong estimates of amount of rows....
8
votes
1
answer
443
views
What is the StatementParameterizationType plan attribute?
I have noticed execution plans sometimes include a StatementParameterizationType attribute.
What is this, what does it mean, and when does it appear?
2
votes
1
answer
868
views
Is there a way to get the Actual Execution Plan for a cancelled query?
Sometimes a query will be taking ages and you don't want to have to run the whole thing. This is exactly the kind of time you may want to see the Actual Execution Plan to figure out why the query is ...
0
votes
1
answer
162
views
SSMS Suggested Indexes and Compability Mode
I am running an old production application which has a backend DB hosted on SQL2008R2 in Compatibility Mode 80 (SQL2000). When I run bits of TSQL to view actual execution plans SSMS is giving me ...
6
votes
1
answer
4k
views
How to list all forced query plans and cancel one
Using SSMS 2016 Query Store I forced a few weeks ago a specific query to use a specific plan. Now every now and then I have the error:
Query processor could not produce a query plan because of the ...
6
votes
2
answers
2k
views
Execution plan percentages don't add up to 100%
I am referring to SQL Server query execution plans to take query cost and then optimize the required things by looking at the plan.
But the total of individual query costs adds up to more than 100%. ...
5
votes
1
answer
2k
views
how to ignore the SSMS (sql server management studio) sql server ansi settings?
The options in Management Studio
On Management studio Tools->Options->Query Execution->SQL Server
there are options that are set and these prevail over the same options that are set on database level....