Hi, I got a performance problem. I am running the Navision 3.6 th on SQL. Since this past 2 weeks, the system has been slow down due to SQL size is increasing rapidly. Now, the size is 210 GB. The maximum load is mostly concentrated on value entry, g/l entry, item ledger entry, ledger dimension, sales line, warehouse entry, and posted document dimension. The load on the processor comes from querying the crystal report on g/l entry, and minimum 20 warehouse transaction threads running simultaniously. I also attached the detailed information. Hope somebody can help us increase the performance… cheers, traitank[B)]
Attachment: Server Detail Info.zip ( 113090bytes )
Hi Traitank, you might want to look at this http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=12015. Best regards, Hynek. www.hmbusinesssolutions.co.uk
And I can recommend you to get hold of the “SQL Resource Kit” available from the newly released “Navision 4.0 Tools CD”. (Hynek actually wrote large parts of it, when he worked for Microsoft!)