Recommendations for Application Server Memory

Hi All, Some times ago we had these recommendations for hardware resources: Small – 2 Cores, 4 GB Ram Medium – 4 Cores, 8 GB Ram Large – 8 Cores, 16 GB Ram These numbers was mapped to Amazon EC2, C3 Instance type. But after latest performance investigation we have found that 4 GB is too small for normal run of Acumatica. 8 gigabytes should be minimum requirements for any Acumatica deployment. So I recommend you increase server memory if you have less than 8 GB. This is important especially for small instances and Amazon deployments. New recommendations are: Small – 2 Cores, 8 GB Ram Medium – 4 Cores,… Read more

Development Tools in Acumatica

Hi Everyone, Today I want to speak about tools and application that Acumatica team uses during development. Development Microsoft Visual Studio 2012+ ReSharper from JetBrains for faster development Databases and SQL Microsoft Sql Server Express + Microsoft Sql Server Management Studio Microsoft Sql Server Profiler My Sql + SQLyog MySQL GUI for MySQL Apex SQL Refactor – SQL Formating Tool Performance DotTrace from JetBrains for performance testing Memory .Net Memory Profil for memory analysing Windbg for deep process dump analysing Sources Git + Stash for sours control and analysing SourseTree + GitExtension as GUI tools for Git. Documentation and Tracking Jira for bugs tracking Confluence for specification, features and documents traking Mockups and Flow WireFrameSketcher… Read more

Reset User Password

Hi Everyone, In Acumatica all passwords are stored as a Hash, so even if you get database, you are not able to login with user password. But in case of trouble you can reset it to new one directly in the database. Just execute this query against the sql: UPDATE Users SET Password = ‘123’, LockedOutDate =null WHERE Username = ‘admin’ Don’t worry about clear text password – Acumatica will automatically calculate new hash on first login operation. LockedOutDate is field where system stores last unsuccessful login attempt date-time. So if your user is locked out you can use this statement to unlock it. Thank you!