July 16, 2008 at 2:55 pm
Hello all,
I am receiving multiple hash and sort warning and can't find too much information on them. From what I understand it is warning me that a query was run that at some point does not fit into memory and may cause it to run slower.
Has anyone have a good understanding of what is going on? Are the more of a tip or a red flag?
Thanks in advance!
Jen
July 17, 2008 at 1:34 am
It's a red flag. It means that a sort or hash couldn't fit into memory and was forced to disk. Either you;re doing massive hashes and/or sorts, or you're low on memory.
I would suggest finding the queries that trigger those warnings. Profiler will help there, and see why they are triggering hast/sort warnings. It may be that a bit of tweaking of code/indexes will eliminate the need for the sort/hash at all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply