When running SQL Server its always a good idea to run regular maintenance...but what should that be when using SAP Business One?
- setting a limit for maximum memory consumption in SQL server
- Checking DB's size growth
- adjust the Cost Threshold for Parallelism to a value higher than it's default
- set daily or weekly reset SQL service schedule
- separate the physical drives for the MDF and LDF file
- provide enough space on physical drive to support virtual memory paging