Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 738
  • Last Modified:

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

Hello,

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

Rose
0
mbatuchic
Asked:
mbatuchic
1 Solution
 
curtis591Commented:
I got an error message today in Enterprise Manager that was Catastrophic Failure that one made me a little nervous also.
0
 
Brendt HessSenior DBACommented:
This is frequently a failure while building an index, usually a timeout failure. See this FAQ:

http://www.sqlserverfaq.com/content/kbase/kbase.aspx?SRCH=1501

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
go
reconfigure with override
-----------------

This memory is used in sorting.

0
 
mbatuchicAuthor Commented:
Thank you very much.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now