We have a large customer who is seeking assurances over the performance / reliability of Attain on SQL for a large database and a large number of users. Briefly the database size will be around 100Gb with between 200 and 300 concurrent users. Some connections will be via Citrix servers. The customer is a trading organisation, using Sales and Receivables / Purchases & Payables, Inventory, Jobs & Resources plus some custom modules, but they will not use Manufacturing or Warehouse Management We can assume that hardware will not be a problem (that is sufficient resources will be made available to ensure that any performance issues will not be hardware related). Is there anyone out there who has experience of such an installation? Are there any organisations with such an installation who would be prepared to act as a reference site that our customer could contact directly? Any help would be appreciated.
We are an accounting organisation with daily 100 - 150 concurrent users. (soon we will be upgrading to 350 concurrent users) We are using NF 2.6D en SQL 2000 with a 30 Gb database Nog really as big as your customer, but hopefully this helps The performance of are system is very well!
Thanks Ronald! Is it ok for me to e-mail you for additional information? Regards David
quote:
Originally posted by RR
We are an accounting organisation with daily 100 - 150 concurrent users. (soon we will be upgrading to 350 concurrent users) We are using NF 2.6D en SQL 2000 with a 30 Gb database Nog really as big as your customer, but hopefully this helps The performance of are system is very well!
Hi Ronald I have seen your message and I ask you more information, if possible, concern your Navision System (for example Hardware configuration, if the users post at the same time, etc.). My e-mail address is francesco.fiorenza@aurongroup.com I need information urgently. Thanks for all and sorry for my bad english.
We are having significant problems on a 25GB SQL Database because we have 6 General Ledger Dimensions and produce 100 account schedules every month based on these dimensions and it brings the system to it’s knees. We have thrown more memory and disk at it but am still having problems. David
We also found that the use of Advanced Dimensions affects the performance of big databases on SQL. I think it is a known issue at Microsoft.
Any news of a fix? David