Sort Warnings | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sort Warnings

On one of my Web apps Profiler has been reporting a significant amount of sort warnings. Is there a way I can capture which queries are causing this or what is considered too much of an amount of Sort warnings.
This does not include sort operations from the creation of indexes, only sort operations within a query (for example, an ORDER BY clause used in a SELECT statement). BOL mention:
The Sort Warnings event class can be used to monitor query performance. If a query involving a sort operation generates a Sort Warnings event class with an Event Sub Class data column value of 2, the performance of the query can be affected because multiple passes over the data are required to sort the data. Investigate the query further to determine whether the sort operation can be eliminated. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.