SAP Business One for Beginners

You have SAP Business One? This is a great option, if optimized. The more important is a appropriate hardware (number of processors, memory and RAID array),  Database size, queries with high programming quality (fastest queries),  periodic shrink job for transaction logs  and all data files. Split your data files with a fixed size (check your DBA about it) and expansion. Customized functions for long queries is not recommended. If possible, use all default tools available in SAP B1 (SAP Standards). In last case, use AddOns.

1. If possible, leave a memory for OS and free memory for all database (look the data file size or data files). Minimum 50% of your data file. For example: Your data file have 10Gbytes. Leave free 5Gbytes in memory RAM.
2. One time per week, make a shrink job for all data base files and transaction log (remember to set a simple mode before, and return to full when completed).
3. Construct a fastest queries (maximum arguments in WHERE or HAVING). To use Crystal Reports, input all parameters before CR execution. Then CR will allocate a big quantity of memory pages. NEVER select everything.
4. Use RAID 10. I recommend minimum 4 SAS HD. More than this, is better. Check your RAID controller if RAID 10 is supported and max numbers of HDs.
5. Use separate HD in RAID 1 for OS.
6. If you use a VMWare, do the same setup.
7. Remove all used sketch documents.
8. Check your database is configured to SELECT without LOCK. Command used to change database method is showed below. IMPORTANT: CHECK YOUR DBA FIRST.

ALTER DATABASE SBO_COMPANY SET READ_COMMITTED_SNAPSHOT ON;

Last and no more important: Make a donation.

Have a Good Job.