Hardware Recommendation for 1 DB with 200 Companies

johanna

Dear all,

If I have one database with 200 companies for NAV 2013 R2, what is the recommendation for hardware?
Example : Whether I must use SQL Server Enterprise edition or Standard edition?
Please help. Thank you.

thegunzo

@johanna, can you go to MultiTenant configuration ?

Marije_Brummel

I've helped a lot of customers with more than 100 companies in their database and there is more to it than just the number of them.

The number of users and Application areas that are used are more important than the number of companies.

Also the size of the companies is important.

Normally it should work fine with the standard edition of SQL Server. What can be a challenge is the maintenance window. You need a script that is smart enough to only maintain tables that are actually used.

For a customer with over 1000 companies in one database I created a script that kept track of which companies had changes to reduce the effort of SQL finding fragmented indexes.

johanna

Dear Mark,

Thank you