Database Server Memory
Get better performance by providing a significant amount of RAM to the database server to allow the SQL Server to cache large portions of a database. Memory requirements depend on each client’s application specifications.
Database File IO
This spreads My Company Name, LLC database files across multiple disks.
Database Authentication
For better performance, consider using SQL Server authentication rather than Windows integrated authentication, which showed a 15-25% performance decline in testing. This is due to the high degree of multi-threading used by OneStream causing many database connections to be created simultaneously and requiring many database connection authentication calls.
Database Properties
Enable Autogrowth for all database files and use ten Megabytes. See
http://support.microsoft.c om/kb/315512
Database Instance Tuning
SQL Server Memory Parameters
Max Server Memory (In MB) (Recommend Value = [Server RAM – 2GB])
Database Server
Performance testing shows significant improvements with SQL Server over base 2016, so we recommend SQL server 2012, 2014,2016, 2017, 2019 Enterprise Edition.
Application Server
Create separate application servers for each server type.
General Server:
-
High Server Demands (Concurrency)
-
User interface request, queries, and reports
Stage Server:
-
High Server Demands (Mapping)
-
Data loading and transformation
-
May use significant amounts of CPU time and RAM.
Consolidation Server:
-
High Server Demands (Calculations)
-
Analytic Model Calculations and Consolidations
-
May use significant amounts of CPU time and RAM.
