<div>
Hi, 
 
You didn't provide us with the query. Basing on this screen only you are querying columns which are not included in an index and index has been choosen, therefore even if it has clusterd index key values in its leafs SQL is looking to PK for other columns. 
Modify your index accordingly by adding columns (main or included - depends on query which we don't see) or create new covering index if query is worth doing that - is being frequently executed etc. 
 
Regards, 
Daniel
</div>

<div>
Please tell us on what basis you believe we can answer your question without seeing the code that generated it, the schemas of the queried tables, or a full execution plan: &nbsp; Mind reading, Seance, or 'The Force'.
</div>

<div>
----This is the Query--- 
 

<pre><code class="code-10 nolinks" id="code-20-42378858-1">WITH [CTEOrderedUpdate]
		 AS
		 (
			SELECT TOP(@MaxRows)
			 [Uid],
			 [AgentName],
			 [Step],
			 [StepInProgress],
			 [ProcessCount],
			 [DateStarted],
			 [DateFinished]
			FROM
			 [dbo].[BlobMigrationQueue] WITH(ROWLOCK, UPDLOCK, READPAST,Index=IX_BlobMigrationQueueGet)
			WHERE
			 [Step] = 0 AND
			 [Failed] = 0 AND
			 [StepInProgress] = 0
		 )
		 UPDATE
			[CTEOrderedUpdate]
		 SET
			[StepInProgress] = 1,
			[AgentName] = @AgentName,
			[ProcessCount] = [ProcessCount] + 1,
			[DateStarted] = SYSDATETIME(),
			[DateFinished] = NULL
		 OUTPUT
			inserted.[Uid]
		 INTO
			@Batch([Uid])
</code></pre>
</div>

<div>
Thank you Pawan. 
We found the solution.
</div>

<div>
<div class="content wysiwyg-content">
Please find the screenshot and suggest us how to fine tune: This is SQL Server 2016 
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1212195/Key.jpg" target="_blank" title="Key.jpg (99 KB)"><img alt="Key.jpg" class="file-block lazyload" style="max-width: 335px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w47/1212195/Key.jpg" /></a>
</div>
</div>

Key.jpg

Please find the screenshot and suggest us how to fine tune: This is SQL Server 2016


MS SQL Perofrmance issue with T-sql

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.