SQL performance Item sorting Search Description

erben

Hi all,

One of my customers converted from Native to SQL a few weeks ago. Overall performance is OK.
There is one situation however that shows unacceptable performance.

If I browse through an Item Card (even a newly created one with only "No." on it) while the sorting is set to "Search Description" the performance is poor. Using the Client Monitor we can see that sometimes a FINDNEXT can take up to a minute.
Using other secundary keys is no problem at all, just the Search Description.
NAV Version = 2009sp1 (objects 3.70), SQL = 2008 R2

Any ideas?

Thanks.

Marije_Brummel

Is the SQL Index for Search Description enabled?

Kishorm

Check that MaintainSQLIndex property is set to Yes and that SQLIndex property is blank.

kriki

And that you have done maintenance on your indexes (like rebuild index or at least updated statistics on them)