Sort Warnings / Multi Pass Sort

21 Oct 2005 12:12 PM

parasada

I traced my app for some perf related issues and found that a proc is giving
Sort warnings (EventClass) and Multi Pass Sort (EventSubClass). Where in the
query should I start looking into the problem? when do we get these warnings
- BOL/msdn doesn't explain in dtl; it just says that - The Sort Warnings
event class indicates that sort operations do not fit into memory. any
additional info/inputs will be appreciated

TIA

21 Oct 2005 12:22 PM

Dan Guzman

Examine the execution plan of the query in question. Depending on the
particulars of the query, it may be possible to add indexes to mitigate the
need for the large sort(s).

--
Hope this helps.

Dan Guzman
SQL Server MVP

Show quote

"parasada" <paras***@discussions.microsoft.com> wrote in message
news:3CB74AE4-75BA-48E9-98E9-E64B51CC5409@microsoft.com...
>I traced my app for some perf related issues and found that a proc is
>giving
> Sort warnings (EventClass) and Multi Pass Sort (EventSubClass). Where in
> the
> query should I start looking into the problem? when do we get these
> warnings
> - BOL/msdn doesn't explain in dtl; it just says that - The Sort Warnings
> event class indicates that sort operations do not fit into memory. any
> additional info/inputs will be appreciated
>
> TIA