THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

A new superpower for SQL query tuners – Number of Rows Read

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at: http://blogs.lobsterpot.com.au/2015/12/12/a-new-superpower-for-sql-query-tuners-number-of-rows-read/

Published Saturday, December 12, 2015 12:26 PM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Greg Gonzalez said:

Thanks Rob! This is great news all around, and indeed an exciting opportunity for Plan Explorer. Look for something soon... ;-)

December 14, 2015 5:20 PM
 

Olivier said:

Hello,

I have that kind of behavior from my server, but in this case I don't know how I can solve this... I have a very big partitionned table, the seek gives me Something like :

[ptnId15]>=RangePartitionNew(@myvar,(1),date1,date2,....

[ptnId15]<RangePartitionNew(@MyOtherVar,(1),date1,...

the information shows me that it uses a partition range from (in my case) 5 partitions

Then I have a predicate with the field >= @Myvar and field < @Myothervar

this gives me a residual IO... 1.200 Million read for 990K rows...

Any idea on this ?

May 3, 2017 10:58 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

News

News? Haven't you read my blog?

My Company


Can't find something?

Contact Me

IM: rob_farley@hotmail.com
Twitter: @rob_farley
Skype: rob_farley
E: rob_farley@hotmail.com

MVP (SQL Server)




Certifications








Adelaide SQL UG

Privacy Statement