Demand Planning
- Demand Planning Server Configuration
This article details the server configuration for the Demand Planning application, providing a technical overview for newcomers to the system administration team. Demand Planning relies on a robust server infrastructure to process large datasets and provide accurate forecasting. This document covers hardware specifications, software requirements, and key configuration parameters. Please refer to System Architecture Overview for context within the broader IT infrastructure.
Overview
The Demand Planning application is a critical component of our supply chain management system. It utilizes historical sales data, market trends, and promotional activities to predict future demand for our products. This information is crucial for inventory management, production planning, and logistics. The server infrastructure is designed for high availability and scalability to handle peak processing loads. Understanding the Data Flow Diagram is helpful when troubleshooting.
Hardware Specifications
The Demand Planning application is hosted on a dedicated server cluster. Each node in the cluster meets the following minimum specifications:
| Component | Specification | |
|---|---|---|
| CPU | 2 x Intel Xeon Gold 6248R (24 cores per processor) | |
| RAM | 256 GB DDR4 ECC Registered RAM | |
| Storage | 2 x 1 TB NVMe SSD (RAID 1) for OS and Application | 8 x 4 TB SAS HDD (RAID 6) for Data Storage |
| Network Interface | 2 x 10 Gigabit Ethernet | |
| Power Supply | Redundant 1200W Power Supplies |
These specifications are based on projected data volumes and processing requirements as outlined in the Capacity Planning Document. Regular monitoring of server resource utilization is performed via Server Monitoring Dashboard.
Software Requirements
The Demand Planning application relies on a specific software stack. Version compatibility is critical for stability and performance.
| Software | Version | Purpose |
|---|---|---|
| Operating System | Red Hat Enterprise Linux 8.6 | Server OS |
| Database Server | PostgreSQL 13 | Data storage and retrieval |
| Application Server | Tomcat 9.0.46 | Hosts the Demand Planning web application |
| Java Runtime Environment | OpenJDK 11 | Runs the application server |
| Message Queue | RabbitMQ 3.9.1 | Asynchronous task processing |
All software packages are managed through our internal package repository detailed in the Software Management Policy. Software updates are performed during scheduled maintenance windows, as documented in the Maintenance Schedule.
Configuration Parameters
Several key configuration parameters impact the performance and stability of the Demand Planning application. These are managed through configuration files and environment variables.
Database Configuration
The PostgreSQL database is configured for optimal performance with the following settings:
| Parameter | Value | Description |
|---|---|---|
| `shared_buffers` | 64GB | Amount of memory dedicated to shared memory buffers. |
| `work_mem` | 256MB | Amount of memory used by internal sort operations and hash tables. |
| `maintenance_work_mem` | 4GB | Amount of memory used for maintenance tasks like VACUUM and CREATE INDEX. |
| `effective_cache_size` | 192GB | Estimate of the total amount of memory available for caching. |
These settings are monitored and adjusted as needed by the Database Administration Team. Connection pooling is enabled in Tomcat to reduce database connection overhead; see Connection Pooling Configuration.
Tomcat Configuration
Tomcat is configured with a dedicated instance for the Demand Planning application. Key settings include:
- Maximum heap size: 64GB
- Thread pool size: 200
- Connector port: 8080
- SSL/TLS enabled with a valid certificate obtained from Certificate Authority.
RabbitMQ Configuration
RabbitMQ is configured to handle asynchronous tasks such as data import and report generation. Key settings include:
- Number of queues: 100
- Message TTL: 24 hours
- Mirroring enabled for high availability. See RabbitMQ Clustering.
Security Considerations
Security is paramount. The Demand Planning server is protected by a firewall and intrusion detection system. Access to the server is restricted to authorized personnel only, as defined in the Access Control Policy. Regular security audits are conducted by the Security Team. All data is encrypted at rest and in transit. The server adheres to all relevant compliance regulations as outlined in the Compliance Documentation.
Troubleshooting Resources
- Application Logs: Location and format of application logs.
- Database Logs: Location and format of database logs.
- Server Logs: System logs for hardware and OS-level issues.
- Known Issues List: A list of common problems and their solutions.
- Contact Support: How to reach the support team.
Intel-Based Server Configurations
| Configuration | Specifications | Benchmark |
|---|---|---|
| Core i7-6700K/7700 Server | 64 GB DDR4, NVMe SSD 2 x 512 GB | CPU Benchmark: 8046 |
| Core i7-8700 Server | 64 GB DDR4, NVMe SSD 2x1 TB | CPU Benchmark: 13124 |
| Core i9-9900K Server | 128 GB DDR4, NVMe SSD 2 x 1 TB | CPU Benchmark: 49969 |
| Core i9-13900 Server (64GB) | 64 GB RAM, 2x2 TB NVMe SSD | |
| Core i9-13900 Server (128GB) | 128 GB RAM, 2x2 TB NVMe SSD | |
| Core i5-13500 Server (64GB) | 64 GB RAM, 2x500 GB NVMe SSD | |
| Core i5-13500 Server (128GB) | 128 GB RAM, 2x500 GB NVMe SSD | |
| Core i5-13500 Workstation | 64 GB DDR5 RAM, 2 NVMe SSD, NVIDIA RTX 4000 |
AMD-Based Server Configurations
| Configuration | Specifications | Benchmark |
|---|---|---|
| Ryzen 5 3600 Server | 64 GB RAM, 2x480 GB NVMe | CPU Benchmark: 17849 |
| Ryzen 7 7700 Server | 64 GB DDR5 RAM, 2x1 TB NVMe | CPU Benchmark: 35224 |
| Ryzen 9 5950X Server | 128 GB RAM, 2x4 TB NVMe | CPU Benchmark: 46045 |
| Ryzen 9 7950X Server | 128 GB DDR5 ECC, 2x2 TB NVMe | CPU Benchmark: 63561 |
| EPYC 7502P Server (128GB/1TB) | 128 GB RAM, 1 TB NVMe | CPU Benchmark: 48021 |
| EPYC 7502P Server (128GB/2TB) | 128 GB RAM, 2 TB NVMe | CPU Benchmark: 48021 |
| EPYC 7502P Server (128GB/4TB) | 128 GB RAM, 2x2 TB NVMe | CPU Benchmark: 48021 |
| EPYC 7502P Server (256GB/1TB) | 256 GB RAM, 1 TB NVMe | CPU Benchmark: 48021 |
| EPYC 7502P Server (256GB/4TB) | 256 GB RAM, 2x2 TB NVMe | CPU Benchmark: 48021 |
| EPYC 9454P Server | 256 GB RAM, 2x2 TB NVMe |
Order Your Dedicated Server
Configure and order your ideal server configuration
Need Assistance?
- Telegram: @powervps Servers at a discounted price
⚠️ *Note: All benchmark scores are approximate and may vary based on configuration. Server availability subject to stock.* ⚠️