Server Requirments

soni_al
Member Posts: 32
Hello Experts,
We are going to implement Nav 2009 and to use Sql datatabase. We are reviewing hardware equipment if they support our transaction amount of data
We do every day about 1500 sales orders with 10 lines( in total 15000 lines) and about 100 purchase orders with 30 lines in total (3000 lies).
We have 40 concurrent users.
Is a big amount 18000 lines in a day to be posted in Nav. Does have any problem with the performance (the speed ) of the system this amount of data and 40 concurrent users.
Does support the server HP Proliant Dl 380 g5 Ride 5?
Best Regards
We are going to implement Nav 2009 and to use Sql datatabase. We are reviewing hardware equipment if they support our transaction amount of data
We do every day about 1500 sales orders with 10 lines( in total 15000 lines) and about 100 purchase orders with 30 lines in total (3000 lies).
We have 40 concurrent users.
Is a big amount 18000 lines in a day to be posted in Nav. Does have any problem with the performance (the speed ) of the system this amount of data and 40 concurrent users.
Does support the server HP Proliant Dl 380 g5 Ride 5?
Best Regards
0
Comments
-
If you search Mibuso you will find lots of post concerning hardware. They will recommend various things, including not using RAID 5. A properly configured and tuned NAV system is well capable of supporting the transaction volume you describe.
The HP DL3XX Line is very popular in NAV implementation. Just not with RAID 5.
Feel free to post additional more specific questions as they arise.There are no bugs - only undocumented features.0 -
Thank you for your reply,
So you suggest Ride 10? I'm in very confuzed if the Ride5 can do with this volume of data transaction.
Regards.0 -
RAID 10 has better write performance than RAID 5.
Just as important is that the transaction log file is placed on its own dedicated physical disk array (RAID 1 or 10). This means that no other files are ever placed on that array. This includes other transaction logs.There are no bugs - only undocumented features.0 -
A typical NAV server config with the DL380 might be something like this:
Using 16 - 146 GB 15K SAS disk:
ARRAY 0 - RAID 1 (2*146 GB) - Operating System, Program Files
ARRAY 1 - RAID 1 (2*146 GB) - SQL System databases
ARRAY 2 - RAID 1 (2*146 GB) - Transaction Log - Live DB
ARRAY 3 - RAID 1 (2*146 GB) - Transaction Log - Test DB
ARRAY 4 - RAID 10 (8*146 GB) - NAV Data files
There's some open discussion of the best use for RAID 1. One option is to move the SQL System Databases to Array 4 and use this for backups. Another option is keeping Temp DB here.There are no bugs - only undocumented features.0 -
I installed a NAV system with several times higher volume with a similar RAID configuration bbrown described. Also had 32 GB RAM. While the log file has to be written right away, SQL Server will make good use of RAM for caching.
There is also a recommendation to have 1 tempdb file per CPU core. Some recommend to put tempdb on its own spindle.
I imagine as NAV moves to SQL Server only, it will make more use of SQL Server features for performance improvement.David Machanick
http://mibuso.com/blogs/davidmachanick/0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions