Styjun

Was Donald Trump at ground zero helping out on 9-11?

Just how much information should you share with a former client?

Why did I lose on time with 3 pawns vs Knight. Shouldn't it be a draw?

Unknown indication below upper stave

Coworker mumbles to herself when working, how to ask her to stop?

What are the closest international airports in different countries?

How did astronauts using rovers tell direction without compasses on the Moon?

Exploiting the delay when a festival ticket is scanned

What Marvel character has this 'W' symbol?

How can flights operated by the same company have such different prices when marketed by another?

Why would an invisible personal shield be necessary?

Efficiently finding furthest two nodes in a graph

"DDoouubbllee ssppeeaakk!!"

How should I quote American English speakers in a British English essay?

Prepare a user to perform an action before proceeding to the next step

Should I put my name first, or last in the team members list

Did Vladimir Lenin have a cat?

My employer is refusing to give me the pay that was advertised after an internal job move

How to find the three closest (nearest) values within a vector?

On what tickets or flights are Flying Blue XP earned?

Can machine learning learn a function like finding maximum from a list?

How to efficiently shred a lot of cabbage?

Why does one get the wrong value when printing counters together?

Microgravity indicators

Execution Plan missing Actual Partitions Accessed

Execution Plan on Table PartitioningWhat do Clustered and Non clustered index actually mean?partitioning big tables - indexes Azure Export from localDb fails to make indexSQL Server: Strange execution planNeed help understanding and improving query plan (Estimated Number of Rows is very different from Actual Number of Rows)SSMS - SQL Azure v12 preview - unknown property IsNativelyCompiledExtrememly High Estimated Number of Rows in Execution PlanQuery execution plan of same queriesWhat is causing the Execution plan difference between Azure SQL and SQL Server?Simple query with different execution plan when executed from SQL Job agent

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

Using Azure Sql Database, SQL Server Management Studio V. 18.0 Preview 6 (though this problem existed when I was using v 17).
When viewing the execution plan against a partitioned table, the only partition related info I get when I view the properties of a partitioned clustered index seek is "Partitioned | True" (nothing in the XML version either). Nowhere do I see "Actual Partitions Accessed" as is pictured in this post (as example).

Why is it missing?

sql-server azure-sql-database ssms

share|improve this question

edited Mar 27 at 12:35

dudeNumber4

asked Mar 26 at 21:24

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  are you looking at the actual execution plan? Not the estimated or cached one?
  
  – Martin Smith
  Mar 28 at 4:06
  
  

  
  
  
  

add a comment | 

0

Using Azure Sql Database, SQL Server Management Studio V. 18.0 Preview 6 (though this problem existed when I was using v 17).
When viewing the execution plan against a partitioned table, the only partition related info I get when I view the properties of a partitioned clustered index seek is "Partitioned | True" (nothing in the XML version either). Nowhere do I see "Actual Partitions Accessed" as is pictured in this post (as example).

Why is it missing?

sql-server azure-sql-database ssms

share|improve this question

edited Mar 27 at 12:35

dudeNumber4

asked Mar 26 at 21:24

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  are you looking at the actual execution plan? Not the estimated or cached one?
  
  – Martin Smith
  Mar 28 at 4:06
  
  

  
  
  
  

add a comment | 

Using Azure Sql Database, SQL Server Management Studio V. 18.0 Preview 6 (though this problem existed when I was using v 17).
When viewing the execution plan against a partitioned table, the only partition related info I get when I view the properties of a partitioned clustered index seek is "Partitioned | True" (nothing in the XML version either). Nowhere do I see "Actual Partitions Accessed" as is pictured in this post (as example).

Why is it missing?

sql-server azure-sql-database ssms

share|improve this question

edited Mar 27 at 12:35

dudeNumber4

asked Mar 26 at 21:24

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

sql-server azure-sql-database ssms

sql-server azure-sql-database ssms

share|improve this question

edited Mar 27 at 12:35

dudeNumber4

asked Mar 26 at 21:24

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

share|improve this question

edited Mar 27 at 12:35

dudeNumber4

asked Mar 26 at 21:24

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

asked Mar 26 at 21:24

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

asked Mar 26 at 21:24

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

2 Answers
2

active

oldest

votes

1

This is strange, I’m using SSMS 18 Preview 7 and I get those properties on Azure and SQL 2019 (just as a quick test).

Azure:

SQL 2019:

Example I used:

CREATE PARTITION FUNCTION pf_test(INT) 
AS RANGE RIGHT FOR VALUES (0)

CREATE PARTITION SCHEME ps_test 
AS PARTITION pf_test ALL TO ([PRIMARY])

CREATE TABLE Foo 
( 
 WorkItem INT NOT NULL 
 , Payload CHAR(300) NOT NULL DEFAULT REPLICATE ('X', 300) 
) ON ps_test(WorkItem)

INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (2) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (2)

SELECT * FROM Foo 
WHERE WorkItem > -1

share|improve this answer

edited Mar 28 at 3:58

CR241

1,04488 silver badges2020 bronze badges

answered Mar 27 at 22:23

Pedro LopesPedro Lopes

3622 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the script; I probably should've included that myself :/
  
  – dudeNumber4
  Mar 28 at 14:08
  

  
  
  
  

add a comment | 

0

The answer was exceedingly simple; @MartinSmith comment (why can't I at mention here?) - include actual execution plan.

share|improve this answer

answered Mar 28 at 14:09

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55366420%2fexecution-plan-missing-actual-partitions-accessed%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

This is strange, I’m using SSMS 18 Preview 7 and I get those properties on Azure and SQL 2019 (just as a quick test).

Azure:

SQL 2019:

Example I used:

CREATE PARTITION FUNCTION pf_test(INT) 
AS RANGE RIGHT FOR VALUES (0)

CREATE PARTITION SCHEME ps_test 
AS PARTITION pf_test ALL TO ([PRIMARY])

CREATE TABLE Foo 
( 
 WorkItem INT NOT NULL 
 , Payload CHAR(300) NOT NULL DEFAULT REPLICATE ('X', 300) 
) ON ps_test(WorkItem)

INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (2) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (2)

SELECT * FROM Foo 
WHERE WorkItem > -1

share|improve this answer

edited Mar 28 at 3:58

CR241

1,04488 silver badges2020 bronze badges

answered Mar 27 at 22:23

Pedro LopesPedro Lopes

3622 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the script; I probably should've included that myself :/
  
  – dudeNumber4
  Mar 28 at 14:08
  

  
  
  
  

add a comment | 

1

This is strange, I’m using SSMS 18 Preview 7 and I get those properties on Azure and SQL 2019 (just as a quick test).

Azure:

SQL 2019:

Example I used:

CREATE PARTITION FUNCTION pf_test(INT) 
AS RANGE RIGHT FOR VALUES (0)

CREATE PARTITION SCHEME ps_test 
AS PARTITION pf_test ALL TO ([PRIMARY])

CREATE TABLE Foo 
( 
 WorkItem INT NOT NULL 
 , Payload CHAR(300) NOT NULL DEFAULT REPLICATE ('X', 300) 
) ON ps_test(WorkItem)

INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (2) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (2)

SELECT * FROM Foo 
WHERE WorkItem > -1

share|improve this answer

edited Mar 28 at 3:58

CR241

1,04488 silver badges2020 bronze badges

answered Mar 27 at 22:23

Pedro LopesPedro Lopes

3622 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the script; I probably should've included that myself :/
  
  – dudeNumber4
  Mar 28 at 14:08
  

  
  
  
  

add a comment | 

This is strange, I’m using SSMS 18 Preview 7 and I get those properties on Azure and SQL 2019 (just as a quick test).

Azure:

SQL 2019:

Example I used:

CREATE PARTITION FUNCTION pf_test(INT) 
AS RANGE RIGHT FOR VALUES (0)

CREATE PARTITION SCHEME ps_test 
AS PARTITION pf_test ALL TO ([PRIMARY])

CREATE TABLE Foo 
( 
 WorkItem INT NOT NULL 
 , Payload CHAR(300) NOT NULL DEFAULT REPLICATE ('X', 300) 
) ON ps_test(WorkItem)

INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (2) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (2)

SELECT * FROM Foo 
WHERE WorkItem > -1

share|improve this answer

edited Mar 28 at 3:58

CR241

1,04488 silver badges2020 bronze badges

answered Mar 27 at 22:23

Pedro LopesPedro Lopes

3622 bronze badges

CREATE PARTITION FUNCTION pf_test(INT) 
AS RANGE RIGHT FOR VALUES (0)

CREATE PARTITION SCHEME ps_test 
AS PARTITION pf_test ALL TO ([PRIMARY])

CREATE TABLE Foo 
( 
 WorkItem INT NOT NULL 
 , Payload CHAR(300) NOT NULL DEFAULT REPLICATE ('X', 300) 
) ON ps_test(WorkItem)

INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (-1) 
INSERT INTO Foo (WorkItem) VALUES (2) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (1) 
INSERT INTO Foo (WorkItem) VALUES (2)

SELECT * FROM Foo 
WHERE WorkItem > -1

share|improve this answer

edited Mar 28 at 3:58

CR241

1,04488 silver badges2020 bronze badges

answered Mar 27 at 22:23

Pedro LopesPedro Lopes

3622 bronze badges

edited Mar 28 at 3:58

CR241

1,04488 silver badges2020 bronze badges

edited Mar 28 at 3:58

CR241

1,04488 silver badges2020 bronze badges

answered Mar 27 at 22:23

Pedro LopesPedro Lopes

3622 bronze badges

answered Mar 27 at 22:23

Pedro LopesPedro Lopes

3622 bronze badges

0

The answer was exceedingly simple; @MartinSmith comment (why can't I at mention here?) - include actual execution plan.

share|improve this answer

answered Mar 28 at 14:09

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

add a comment | 

0

The answer was exceedingly simple; @MartinSmith comment (why can't I at mention here?) - include actual execution plan.

share|improve this answer

answered Mar 28 at 14:09

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

add a comment | 

The answer was exceedingly simple; @MartinSmith comment (why can't I at mention here?) - include actual execution plan.

share|improve this answer

answered Mar 28 at 14:09

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

share|improve this answer

answered Mar 28 at 14:09

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

answered Mar 28 at 14:09

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges

answered Mar 28 at 14:09

dudeNumber4dudeNumber4

1,47611 gold badge2222 silver badges4343 bronze badges