mibuso.com

Microsoft Business Solutions online community
It is currently Sat Oct 25, 2014 4:49 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: NAV limitation in concurrent user
PostPosted: Wed Apr 18, 2012 6:31 am 
Offline

Joined: Thu Oct 06, 2011 4:16 am
Posts: 17
Location: Philippines
Country: Philippines (ph)
I found this info

http://msdn.microsoft.com/en-us/library ... ityContent

Maximum number of concurrent users
(the actual limit depends on your hardware and the workload) 500

Just want to know if this is applicable also if we use MSSQL as NAV database?

Thanks,

Rickris

_________________
NAV Developer since 2006


Top
 Profile E-mail  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Wed Apr 18, 2012 8:09 am 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7701
Location: Milan
Country: Italy (it)
It is for SQL.
The native DB has less scalability.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Wed Apr 18, 2012 9:09 am 
Offline

Joined: Thu Oct 06, 2011 4:16 am
Posts: 17
Location: Philippines
Country: Philippines (ph)
Hi kriki,

Thanks for the quick response, I don't get it your answer
Quote:
It is for SQL.
The native DB has less scalability.


meaning for SQL database NAV max user will be 500 only?

_________________
NAV Developer since 2006


Top
 Profile E-mail  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Wed Apr 18, 2012 1:39 pm 
Offline

Joined: Thu Oct 30, 2008 10:38 am
Posts: 1005
Location: Earth
Country: Netherlands (nl)
Rickris wrote:
meaning for SQL database NAV max user will be 500 only?


Yes, "Only" 500 users maximum.
What kind of project are you facing, because if there is a need for >500 concurrent users, then you might want to look at solutions scaled for large companies, like AX (or if you hate your customer: sap (this might be a bit biased)).

NAV is aimed at small to medium enterprises, the most implementations have <20 concurrent users, others go to about 100-200 maximum (with some exceptions)

_________________
|Pressing F1 is so much faster than opening your browser|
|MCBMSS: 5.0 intro|MCTS:NAV09 839..841|JetReports© Certified Specialist|
|Dynamics Anywhere: Mobile Business Solutions|


Top
 Profile  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Wed Apr 18, 2012 1:57 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12441
Location: Brno
Country: Czech Republic (cz)
Of course, this "500 limit" is just number somehow created on some tests. Of course, you can have more users, but all depends on specific solution. Some solutions could be used with problems with few users like 20, and some solutions will not have problem with 900 users.

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Wed Apr 18, 2012 2:08 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7701
Location: Milan
Country: Italy (it)
And of course it depends also on what those 900 users do.
If they are all 900 users entering sales lines at the rate of 1 line per second, you have a problem (=900 inserts in "Sales Line" per second). If they are all entering sales lines at the rate of 1 line per hour (=900 lines per hour=15 lines per minute) and for the rest they sleep , NAV can handle a lot more users.

It also depends on the number of companies. If you have only 1 company for those 900 users (at 1 line per second), you have a problem. If each of them is working in its own company, it is not a problem.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Thu Apr 19, 2012 3:20 am 
Offline

Joined: Thu Oct 06, 2011 4:16 am
Posts: 17
Location: Philippines
Country: Philippines (ph)
Hi All,

Thanks for the reply, I really appreciate all of that, I talked to one of MS evangelist for dynamics and they claimed that the largest installation of NAV is 1000+ concurrent user and it's currently in europe.

the industry is remittance(money transfer) and cargo..
I have in mind that each branch will have treated as 1 company.

say I have 900 branches it means 900 company in 1 database, this will prevent me from locking issue right? ofcourse infra issue regarding network(bandwidth) and hardware.

in each branch there are 3 users. 3 * 900 = 2,700 concurrent users. the transaction will be sales and collections only on the site. main requirements is real time.

I want to seek your thoughts on this. Please help.

Thanks,

Rickris

_________________
NAV Developer since 2006


Top
 Profile E-mail  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Thu Apr 19, 2012 6:55 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12441
Location: Brno
Country: Czech Republic (cz)
900 companies in one DB have another problems. Each company will include all tables from NAV, even they are empty. Each change in design of a table in NAV will need to change 900 tables on SQL, it will take time. Even backup this DB with many tables could be hard (900*around 1100 tables per company in W1 = nearly one million of tables...).

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Thu Apr 19, 2012 9:49 am 
Offline

Joined: Thu Oct 06, 2011 4:16 am
Posts: 17
Location: Philippines
Country: Philippines (ph)
Hi Kine,

Thanks for the inputs, I'll noted that. #-o #-o

_________________
NAV Developer since 2006


Top
 Profile E-mail  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Fri Apr 20, 2012 4:57 am 
Offline

Joined: Thu Oct 06, 2011 4:16 am
Posts: 17
Location: Philippines
Country: Philippines (ph)
any other inputs? please help :cry:

_________________
NAV Developer since 2006


Top
 Profile E-mail  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Sun Apr 22, 2012 11:59 am 
Offline

Joined: Sun Feb 28, 2010 10:38 am
Posts: 11
Country: India (in)
May be you can map each Branch as a "Responsibility Center" / "Location" and tag it to the respective users.

Regards,

Sridhar


Top
 Profile E-mail  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Sat Apr 28, 2012 3:28 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7701
Location: Milan
Country: Italy (it)
kine wrote:
900 companies in one DB have another problems. Each company will include all tables from NAV, even they are empty. Each change in design of a table in NAV will need to change 900 tables on SQL, it will take time. Even backup this DB with many tables could be hard (900*around 1100 tables per company in W1 = nearly one million of tables...).

Mark Brummels trick for that is to put DataPerCompany=FALSE for tables that are not used. That is a lot of work to do, but it also diminishes a lot the no. of tables in the DB.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: NAV limitation in concurrent user
PostPosted: Sun Apr 29, 2012 8:43 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12441
Location: Brno
Country: Czech Republic (cz)
Yes, but you must be sure what you are doing that the table will be restored to correct state when someone from one of the 900 companies will start using some new functionality, which was never used before...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 10 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: