mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 1:00 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Server Requirments
PostPosted: Mon Nov 22, 2010 11:03 pm 
Offline

Joined: Tue Jul 28, 2009 5:14 pm
Posts: 21
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


Top
 Profile E-mail  
 
 Post subject: Re: Server Requirments
PostPosted: Tue Nov 23, 2010 1:51 am 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2573
Location: MA
Country: United States (us)
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.


Top
 Profile E-mail  
 
 Post subject: Re: Server Requirments
PostPosted: Thu Nov 25, 2010 6:20 pm 
Offline

Joined: Tue Jul 28, 2009 5:14 pm
Posts: 21
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.


Top
 Profile E-mail  
 
 Post subject: Re: Server Requirments
PostPosted: Thu Nov 25, 2010 6:31 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2573
Location: MA
Country: United States (us)
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.


Top
 Profile E-mail  
 
 Post subject: Re: Server Requirments
PostPosted: Thu Nov 25, 2010 6:43 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2573
Location: MA
Country: United States (us)
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.


Top
 Profile E-mail  
 
 Post subject: Re: Server Requirments
PostPosted: Thu Nov 25, 2010 8:57 pm 
Offline

Joined: Fri Aug 06, 2004 9:30 pm
Posts: 899
Location: Richardson
Country: United States (us)
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/


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: