Anyone running a Navision Database greater than 30GB with 240 concurrent users out there. Can the system handle this number of users / transactions or is it pushing the boundaries for the technology.
Current system runs on a Citrix farm, using SQL 2005 and is expected to grow to 240 users.
Does anyone have any real life examples of this size of database. What is the performance / transaction times like?
What is the optimum configuration in terms of hardware / Memory?
Has David said, it depends a lot of users are supposed to do. Can you divide your users in terms of groups?
10% - Posting Invoices70% - Checking Orders
I don’t how deep you know Navision and other ERP’s, but posting generates a lot of data, and I also think that it will have much more than 30G Gigs with 240 users.
We have a simirl size database - 240 concurrent users and 30 gig
We have 100+ people creating approximately 30000 cash sales per month.. We have experienced problems with locking. Posting of cash invocies has been split from the online transaction to overnight
I remember reading this on the specifications and limitations for the C/SIDE Database Management System
(DBMS) and its application objects:
Maximum number of physical disk files
Database file size
Maximum number of objects in a database
Maximum number of characters in application object names
Maximum number of characters in a password
Maximum number of concurrent users
(the actual limit depends on your hardware and the workload)
Maximum cache size