Azure Configurations
(Azure Only or if Azure Elastic Pool Being Used)
Azure Subscription Settings
The Azure Subscription Settings must be filled in, as they are used to login and retrieve Azure settings and data. This section will should be populated when using Azure Elastic Pool or if using Scale Sets (which is a feature that will available in a future release).
Environment Monitoring
The Environment Monitoring section configures how and how often metrics are collected. What is available for metrics or monitoring is based on configurations made in the OneStream Server Configuration Utility. See Installation and Configuration Guide.
URL for the Automatic Recycle Service
Used to specify the address of the recycle management service. The protocol for the address should be set to however the service is deployed (https or http) and the port (default is 50002). The asterisk will force the service to use the fully qualified domain name of the executing server.
Number of Running Hours Before Automatic Recycle
Used to specify how often the app servers should be restarted. The default is 24.0. Use 0.0 to turn off auto recycling. Fractional numbers may be used in this setting.
Start Hour for Automatic Recycle (0 to 24 UTC)
Used to specify the time period within each day that the server can be recycled. This setting is only used if Number of Running Hours Before Automatic Recycle is set to 24.0. The default setting is 5. With that value, the application servers will be recycled between 5:00am UTC and what the setting for the End Hour for Automatic Recycle is set to.
End Hour for Automatic Recycle (0 to 24 UTC)
Used to specify the time period within each day that the server can be recycled. This setting is only used if Number of Running Hours Before Automatic Recycle is set to 24.0. The default setting is 7. With that value, the application servers will be recycled between 7:00am UTC and what the setting for the Start Hour for Automatic Recycle is set to.
Maximum Number of Minutes to Pause Before Automatic Recycle
Used to specify the maximum number of minutes that the server should pause its ability to run newly queued tasks before recycling. The default setting is 30. This setting is the time period that the server will use to allow previously started tasks to finish. If there are no previously running tasks on the application server, the setting is ignored.
Active Check Update Interval (seconds)
How often system checks for system monitoring (i.e.; deadlocks ...)
Metric Update Interval (seconds)
How often system checks for metric updates.
Server Heartbeat Update Interval (seconds)
How often system updates that this server is alive.
Collect Environment CPU Metrics
How often to collect environment CPU metrics.
Collect Environment Task Metrics
How often to collect environment task metrics (i.e.; running tasks, Queued Tasks …)
Collect Environment Login Metrics
How often to collect environment user login metrics.
Collect Server Set CPU Metrics
How often to collect server set CPU metrics.
Collect Server Set Task Metrics
How often to collect server set task metrics (i.e.; running tasks, Queued Tasks …).
Collect Server Disk Metrics
How often to collect server disk metrics (i.e.; Average Disk read/write per sec…).
Collect Server Memory Metrics
How often to collect server memory metrics (i.e.; Available MBytes…).
Collect Server Network Card Metrics
How often to collect server network card metrics.
Collect SQL CPU Metrics
How often to collect SQL server CPU metrics.
Collect SQL Page Metrics
How often to collect SQL server Page caching metrics (i.e.; Page Life Expectancy…).
Collect SQL Memory Metrics
How often to collect SQL server CPU metrics.
Collect SQL Connection Metrics
How often to collect SQL server connection metrics (i.e.; Number of connections…).
Collect SQL Query Metrics
How often to collect SQL server Query metrics (i.e.; Number of Deletes/Inserts…).
Collect SQL File Metrics
How often to collect SQL server File growth metrics.
Collect SQL Elastic Pool CPU Metrics
How often to collect SQL server Elastic Pool CPU metrics (i.e.; Number of connections…).
Collect SQL Elastic Pool DTU Metrics
How often to collect SQL server Elastic Pool DTU metrics (i.e.; Number of connections…).
Collect SQL Elastic Pool Storage Metrics
How often to collect SQL server Elastic Pool Storage metrics (i.e.; disk storage usage…).
Collect SQL Elastic Pool Workload Metrics
How often to collect SQL server Elastic Pool Workload metrics.
Number Past Metric Readings for SQL Blocking
Used to select the past number of metric values for blocking analysis.
Fragmentation Iteration Count
Used for fragmentation check, every 10 hours if the ActiveCheckUpdateIntervalInSec is set to 60.
Fragmentation Percent Threshold
Used for fragmentation threshold check in percent.
Detailed Logging
If true, then log whenever we enter and exit the metric collection and the Active System check.
Number Hours To Retain Offline Servers
Remove offline servers from the heartbeat table after certain number of hours.
Task Load Balancing
Maximum Queued Processing Interval (seconds)
How often the queuing thread checks for new tasks to be run.
Number Past Metric Reading For Analysis
How many metric readings to retrieve for analyzing server demand.
Maximum Queued Time (minutes)
Maximum time to wait for a task to run before it is cancelled.
Maximum Average CPU Utilization
Maximum average CPU utilization before we determine that a server can't take a task.
Task Logging Only
If true will only logs picked up tasks.
Detailed Logging
If true, then log whenever we enter and exit the Task Load Balancing function and what was run.
Database Server Connection
The Azure section in the Database Connection Settings needs to be completed only if Azure database and/or Azure Elastic pool is used.
Sample Azure database connection settings:
Azure Elastic Pool Max DTU Setting
This is a fail-safe setting that the user can’t set the DTU setting above this point.
Azure Elastic Pool Min DTU Setting
This is a fail-safe setting that the user can’t set the DTU setting below this point.
Elastic Pool Name
The name of the elastic pool used with this database connection.
Azure Resource Group
The resource group name that the elastic pool is in.
Azure Service Level Objective
The service level used. This setting is used to create application on Azure.
Azure SQL Edition
The Azure SQL Server edition used.
Azure SQL Scaling Type
Manual, Business Rule or ManualAndBusiness Rule. The is used to set the type of scaling that is used to Scale Out or Scale In the SQL Server eDTUs. The default setting should be set to Not Used.
Azure SQL Server Name
The name of the SQL Server. This setting is used to create application on Azure.
Azure SQL Storage Max Size
This is used to specify the database storage size when creating a database on AZURE.
Azure SQL System Business Rule Name
If SQL Scaling Type is set to BusinessRule, this setting must be set to a business rule that is used to scale in/out. The Environment metrics and the database metrics are passed to this rule to properly determine the eDTU scaling.
Azure Server Sets Settings
This setting is used to set up the used scale sets for the different application servers:
The Azure section is used to set the Azure resource group name and the scale set name as it exists on Azure. The Scaling options are used to set the scaling capacity and the Scaling Type (e.g. Manual or BusinessRule). The System Business Rule Name must be set if the Scaling Type is set to Business Rule.
The Behaviors section is used determine how this scale set is used. Whether it can be called by the web server or it is used as a processing server for consolidations and Stage Load.
The General section is used to determine whether this scale set is used and who is its provider (i.e.; Azure, External …).