Error: 1501, Severity: 20, State: 1     Sort failure.....

Posted on 2003-02-26
Medium Priority
Last Modified: 2007-12-19

Error: 1501, Severity: 20, State: 1     Sort failure.....

Has anyone seen the above error message in the SQL Server logs?  Does anybody know what it means and what needs to be done to solve whatever problem?  The severity level seems high and that makes me nervous not being able to determine what it is.  Help please.  There's nothing on BOL or Knowledge Base.  Thanks in advance

Question by:mbatuchic
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 8028526
I got an error message today in Enterprise Manager that was Catastrophic Failure that one made me a little nervous also.
LVL 32

Accepted Solution

Brendt Hess earned 300 total points
ID: 8028603
This is frequently a failure while building an index, usually a timeout failure. See this FAQ:


This can also be an insufficient memory or locks issue.  SQL Server uses sort pages any time a task issues an operation that SQL Server must solve by using sorts.  This includes creating indexes, and also doing GROUP BY, ORDER BY, or DISTINCT on columns not covered by queries...

For this, you can try increasing the SQL Server configuation 'min memory per query'.  By default, it's 1024:
sp_configure 'min memory per query', 2048
reconfigure with override

This memory is used in sorting.


Author Comment

ID: 8220464
Thank you very much.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question