SQL Server Performance

Sort Warnings

Discussion in 'General DBA Questions' started by Raulie, Apr 16, 2004.

  1. Raulie New Member

    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.
  2. satya Moderator

    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.

Share This Page