Blue Mountain RAM is a fast and efficient software solution, however, sometimes implementations are hindered by the performance of servers and sizes of databases. There are five areas where customers can improve their performance of Blue Mountain RAM:
- Hardware Specifications
- Blue Mountain RAM version
- SQL Server Version
- SQL Reporting
- Blue Mountain RAM Database Optimization
Some issues with performance of Blue Mountain RAM begin with the limitations of the physical or virtual servers where the application and/or database is installed. You can improve end user experience with Blue Mountain RAM by upgrading the following areas:
- Random Access Memory (RAM) – Ideally, you want 16-32 GB of RAM on your Blue Mountain RAM servers to assist in performance. The more memory available to the SQL Server, the more memory that SQL Server can use to cache data.
- Central Processing Unit (CPU) – Two or more Processing Cores will aid in improving performance of the software.
- Database File Storage – By placing Data Files (.mdf) and Log Files (.ldf) on separate storage disks, you can optimize writing to the Blue Mountain RAM transaction log.
Blue Mountain RAM Version
Upgrading Blue Mountain RAM to the most current version includes performance enhancements within the application code:
- Blue Mountain RAM Refactored code has been implemented to enhance storage procedures in the software.
- Old database indexes have been modified and new database indexes have been added to improve performance.
SQL Server Version
The version of Microsoft’s SQL server can also limit the performance of Blue Mountain RAM. Some older implementations of Blue Mountain RAM are installed on SQL Server 2008, however, Blue Mountain recommends SQL Server 2012 and 2014 to assist with performance.
Upgrading to SQL 2012 or 2014 includes performance enhancements within the Database Engine implemented by Microsoft, as well as the “Always on Availability Group” feature for Database clusters. This feature enables routing of report execution to a secondary database server with a synchronized copy of the Blue Mountain RAM database. It also assists in relieving the primary database from the impact of shared report queries that can trigger Blue Mountain RAM slowness and timeouts.
Blue Mountain offers SQL Server reporting optimization services that can lead to a possible refactor of certain report queries. The “Subscription & Delivery” feature can be utilized to allow for a scheduled request to deliver a SQL report at a specific time or in response to an event. These reports are delivered in a specific application file format and are received via email.
The Blue Mountain RAM database has a built in procedure that can be performed to optimize the database. A monthly SQL Job can also be created on the SQL Server to purge the stale transaction log rows in the database. Some benefits of this include:
- Blue Mountain RAM Database & Backup file size is reduced by 30% or more after the job is run.
- Blue Mountain RAM Database growth rate is stabilized; improving performance of the application.
- Data and Log files are optimized; assisting with storage and performance of the database.
Upgrading your Blue Mountain RAM server hardware, Blue Mountain RAM application version and SQL Server Version are great starting points for enhancing performance of Blue Mountain RAM. Optimizing SQL Reports and the Blue Mountain RAM Database are additional ways to ensure performance remains exceptional for years to come.
For further information on optimization services Blue Mountain provides, please contact your Regional Sales Manager (RSM) at 800-982-2388. For assistance in utilizing these system performance tips, please contact our friendly Support Technicians at email@example.com.