SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event)

(Ana) Sort warnings events will rise when sort operation is performed in a query and it doesn’t fit into memory. In this case, SQL Server needs to spill the sort operation into tempdb which can result in a very slow physical operation especially if multiple passes to tempdb is needed for sorting the

Read More - Register for Free Membership