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

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

8
Shouts

Shout it

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

published 512 days, 23 hours, 4 minutes ago posted by

kinj312 515 days, 9 hours, 40 minutes ago

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...

category: Data | clicked: 4 | | source: beyondrelational.com | show counter code

tags: SQL Server, TSQL

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout