I am busy performing performance tests of SQL2005 just before we go live with it. So far it behaves quite well but sometimes with big lists it freezes a bit.
Anyway, thought I would share something what is bugging me:
My system: 3.7A database, 4.02 Executables. SQL2005 version 9.0.2196.
I chose to time the re-index of the Contact Search tables recording start and stop time - 190,000 contacts to re-index. Both my SQL2000 & SQL2005 box have pretty much the same architechture.
The problem: SQL2000 takes around 30minutes to run, SQL2005 at least 2 hours. [:(]
I ran a trace and found that the sql command sp_execute (converts Navision code to TSQL commands) seems to be the reason why take longer in SQL2005 also sp_cursorexecute.
Has anyone experienced the same issues with SQL2005?