Hi, My client is running a test on NA3.60 on SQL. Lately there has been bad performance issues and client hanging situations. The database is only 2 GB. And the concurrent users are just 5 or 7. Bad Performance Situation Occurance examples : When lookup in item tracking form for Serial Nos. Postings relating to Item transactions. I went to a lot of links over the forum relating to hardware configration, but having a very basic knowledge of hardware i was more confused with each discussion. I would like somebody to help in having the best configration for the below set which my client has at present, we r ready to configure it to any number of possibities as its just a testing period, Dell PowerEdge2600 Server QTY. Intel Xeon 2.4 GHz/512K, 533MHz FSB 2 1024MB (2X512) DDR 266MHz Registered SDRAM Memory 1 Embedded Intel Gigabit Network Connection 1 (But network is only 100MHz.) LSI Logic 53C 1030 U320 LVD SCSI Controller 2 C4, RAID 5, PERC4/Di, No FBAY HDD 1 Controller, PERC4/DI, ROMB, 128MB 1 36GB Ultra320 (10K RPM, 80-pin) SCSI Hard Drive 4 (Config as RAID 0+1) Thanks in advance… cheers, JHC
Why do You run on SQL? You would have great performance if You run Navision on native DMBS on this server if You also convert Your RAID to RAID-1. For SQL You need more RAM and CPU even for a small environemt like this.
Hi All, Just to add a comment is there any kind of recommendation or checklist document for SQL server sizing and performace check?.
Hello Chandar, in most reason, it is not the hardware. Please check the Performance whitepaper from Microsoft. Please descibe the situation with more details. Do you have locks? MBS Attain works with table locks.
But in this case there’s clearly not enough HW for SQL. For C/SIDE though it’s a good server.
Hello Lars Westman, but the REAL Problem is not the hardware. Yes, RAID 1 is really recommended. We run Attain 3.7 with SQL 2000. HP Proliant DL 360 - 1,7 GB RAM SCSI Contr. inside, SAN Components 20 concurrent User: financials, controlling, HR Database is 20 GB Microsoft (1 Person MBS uns 1 Person SQL Support) has checked our configuration. They found no hardware problem. Martin Brinkmann
That’s Your server (and it sounds OK to me). But tha’ts not what Chandar was running on. Right?
Chandar, I agree with the first posting from Lars. The server you have will be powerful enough for a native database. I am sure that if you convert to the Navsiion native server and move to RAID 1 or RAID 10 you will get much improved performance.
Here’s the checklist you requested: http://www.workthin.com/TuningNavisionForBetterPerformance.pdf
quote:
Originally posted by vadi28
Hi All, Just to add a comment is there any kind of recommendation or checklist document for SQL server sizing and performace check?.
I get an error reading this pdf!
Works for me, both locally and from my website. I’m using Acrobat Reader 6.0.05
quote:
Originally posted by ajhvdb
I get an error reading this pdf!
Hi, I got a very, very nice manual from Siemens called “Sizing PRIMERGY Servers for Navision Financials 2.5, MS SQL Server 7.0 Option”. It’s not so new but wonderfully explained, and it’s written in a way that lets you understand “how to” insted of “which part number should I buy…” The only problem is… how can I upload it to this website?
Alberto, I’d love to see the document, as I’m sure many others would like to as well. I’m not sure how to upload files to this forum.
Also take a look at the new benchmark report for 3.70 on SQL that MBS has done. http://www.mibuso.com/dlinfo.asp?FileID=338
Interesting how the servers are setup with no fault tolerance, i,e using RAID0 for both data and logfile arrays.
quote:
Originally posted by Lars Westman
Also take a look at the new benchmark report for 3.70 on SQL that MBS has done. http://www.mibuso.com/dlinfo.asp?FileID=338
Yes i saw that also. But then it was just a performance test. The danger is that someone could take it for a guideline of how to build a disk system for running Navision on SQL. The old guide had better recommendations for that, buts it’s really old now and it’s hard to tell how much of it that apply on SQL2000 togehter with 3.70.
Hello Hem, The configuration look ok…but the issue is not with the Hardware configuration.Performance also depends on your transaction volume too. Do check for the following 1. If you have change Log setup enabled,because this it self is a reason for performance issues. 2. Check for the Hotfixes for fin.SQL. 3. The transaction volume it self. Regards, Vinod
Hello Hemchander, I have discussed the configuration with my network staff and they say the configuration is quite ok.So the problem is not related to the Hardware configuration. Do check for the following 1. Changelog setup…because this is also responsible for performance issue. 2. FinSQL.exe Hot fix from microsoft. 3. Ofcourse,the transaction volume it self. Regards, Vinod
quote:
I have discussed the configuration with my network staff and they say the configuration is quite ok.So the problem is not related to the Hardware configuration.
Sorry. But I can’t agree on that. Chandar should run C/SIDE DBMS on that server or upgrade the HW. Bit then again. It can also be SW problems, but anyway the HW isn’t enough.
Dear Lars, sorry but I do not agree. We have a Fujitsu-Siemens F200 server as follows: 2 PIII 1100MHz 4 GB of RAM (of wich used 2 only due to limitations on SQL Standard) 2 RAID 1 18GB HD for the DB (10k) 2 RAID 1 18GB HD for the System partition and Log file (in two partitions) (10k) Navision 3.60 SQL 2000 server The DB is 10,5GB, and the concurrent users are up to 26. In normal use, we do not see any unnormal delay.