Not sure what to do about this spill

Plan.pesession (267.0 kB)
avatar image By RichardBrianSmith 97 asked Apr 13 at 09:47 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

Patch your SQL Server 2012 instance from SP1 up to SP3.

You will then be able to use trace flag 7470, which will most likely address this. See:

FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct

avatar image By SQLkiwi ♦ 6.6k answered Apr 13 at 11:12 AM
more ▼
(comments are locked)
avatar image RichardBrianSmith Apr 18 at 09:33 AM

Thanks Paul, This query is a stripped down 'summary' of the 'details' report. I guess the core issue is that its just too slow - and the spill is a consequence of that. Any thing jump out at you about my too-slow code? Richard

10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x650
x463
x119
x109

asked: Apr 13 at 09:47 AM

Seen: 74 times

Last Updated: Apr 18 at 09:33 AM