hardware and software requirements for database

The database is the backbone of your business. It stores all of your data, and it’s what allows you to analyze and make decisions based on that data. If you have a good database, you can run a successful business, but if you don’t have one, or if it’s not working properly, then you’re going to be left in the dark when it comes to making decisions about how to grow your company.

That’s why it’s so important to build an effective database—and why we’ve created this guide on how to do just that.

hardware and software requirements for database

Hardware requirements for the DBMS and the Administration Server

The following tables give the recommended minimum hardware requirements to a DBMS and Administration Server obtained during tests. For a complete list of operating systems and DBMSs supported, please refer to the list of hardware and software requirements.

Administration Server and SQL Server are on different devices, the network includes 50 000 devices

Configuration of the device that has Administration Server installed

HardwareValue
CPU4 cores, 2 500 MHz
RAM8 GB
Hard drive300 GB, RAID recommended
Network adapter1 Gbit

Configuration of the device that has SQL Server installed

HardwareValue
CPU4 cores, 2 500 MHz
RAM16 GB
Hard drive200 GB, SATA RAID
Network adapter1 Gbit

Administration Server and SQL Server are on the same device, the network includes 50 000 devices

Configuration of the device that has Administration Server and SQL Server installed

HardwareValue
CPU8 cores, 2 500 MHz
RAM16 GB
Hard drive500 GB, SATA RAID
Network adapter1 Gbit

Administration Server and SQL Server are on different devices, the network includes 100 000 devices

Configuration of the device that has Administration Server installed

HardwareValue
CPU8 cores, 2.13 GHz
RAM8 GB
Hard drive1 TB, with RAID
Network adapter1 Gbit

Configuration of the device with SQL Server installed

HardwareValue
CPU8 cores, 2.53 GHz
RAM26 GB
Hard drive500 GB, SATA RAID
Network adapter1 Gbit

The tests were run under the following settings:

  • Automatic assignment of distribution points is enabled on the Administration Server, or distribution points are assigned manually in accordance with the recommended table.
  • The backup task saves backup copies to a file resource located on a dedicated server.
  • The synchronization interval for Network Agents is set as specified in the table below.Synchronization interval for Network AgentsSynchronization interval (minutes)Number of managed devices1510 0003020 0004530 0006040 0007550 000150100 000

Server Software Requirements

  • Supported Operating Systems:
    • Windows Server 2022 (including Server Core), 2019, 2016, 2012, 2008
    • Windows 10, 8, 7, Vista (Ultimate or Business)
  • Supported Databases:
    • SQLite (default)
      • only recommended for smaller installations (1 – 100 users)
    • Microsoft SQL Server:
      • Versions 2005 or higher (Express Edition or better)
      • Including High Availability features (Always On Availability Groups, Windows Server Failover Cluster)
    • PostgreSQL 9.0 or higher
    • Microsoft Azure SQL DB
  • Microsoft .NET Framework:
    • 4.5+ is required (4.6.1 default, installed for you)
  • Supported versions of IIS or IIS Express:
    • IIS Express versions 8+ (default, installed for you)
    • IIS versions 7+

Note: Pleasant Password Server does not support Windows 2003

Server Hardware Requirements

With the release of version 7, PPASS requires a 64-bit processor; use version 6 for 32-bit processors.

  • Micro installation (<1k entries; 1-10 users):
    • Dual-Core 1.6 Ghz or higher
    • 2 GB RAM
    • 500 MB free disk space
  • Small installation (1k-10k entries; 10-100 users):
    • Dual-Core 2 Ghz or higher
    • 4 GB RAM
    • 1 GB free disk space
  • Medium installation (10k+ entries; 100-1,000 users):
    • Quad-Core 2 Ghz or higher
    • 8 GB RAM
    • 2 GB free disk space
  • Large installation (100k+ entries; 1,000-10,000 users):
    • Contact Us
  • Very Large installation (1M+ entries; 10,000+ users):
    • Contact Us

Notes:

  • Additional RAM is recommended as the database size grows, for optimal performance.
  • Additional resources should be added when using MS-SQL, PostgreSQL, or Azure databases.
    • For example, MS-SQL Standard itself requires 1 GB RAM and 6 GB free disk space
  • Each database software has their own additional hardware requirements depending on installed components (please refer to vendor websites)
  • The Server Requirements above already include database calculations with a default SQLite database.

Other Considerations

  • Pleasant Password Server will operate in a virtualized environment (VMWare or Hyper-V).
  • Pleasant Password Server can run on the same machine as other applications. Pleasant Password Server will require sufficient RAM and CPU to operate normally, however (see the next point),
  • For maximum security, Pleasant Password Server should be installed on a dedicated system or at least on a system with applications serving the same level of security/sensitivity. Access to these systems should then be restricted. While all sensitive data in Pleasant Password Server is either securely hashed or encrypted, it is a best practice for security to limit any opportunities for foul play.

KeePass Client Requirements

Supported operating systems:

  • Windows 11, 10, 8.1, 8, 7, Vista
  • Windows Server 2022, 2019, 2016, 2012, 2008

Prerequisites:

  • Microsoft .NET Framework 4.5+

hardware requirements for database management system

D M F A S 6 A R C H I T E C T U R E
The DMFAS 6 system has been designed using the three-tier architecture. This type of architecture is
made up of three separate processes. The back-end tier stores the data in a database server, the middle
tier runs an application server that handles most of the processing, and the user-facing tier runs on
Even though this is the most recommended configuration it would be possible to
install the database and the application server on the same server. In an intranet/internet environment
the final decision should consider the needs of the institution, for example, the number of debt
instruments, the type of instruments, the number of users, the workload of the machine, the projected
use of the system, etc.
The present recommendations are based on a configuration where one server hosts the database and a
separate one hosts the application server software and components of DMFAS 6.


D A T A B A S E S E R V E R
In general, the DMFAS system runs on every platform compatible with the latest Oracle releases:
Oracle Release Operating System
11gRx 12cRx MS WS 2012 SP2 MS WS 2016 Linux/Unix/Solaris/AIX
x stands for Release 1 or 2
Additional memory, processor speed and disk space might be needed if other software is installed.
Hardware specifications for servers running another network operating system should have equal
performance and capacity and must be compatible with Oracle RDBMS. It Is recommended to have an
automatic detection software for monitoring updates and proactive support notifications.
Hardware, Software and Training Requirements for DMFAS 6 | 5
Component Specifications
CPU1 Intel® / Core i(7/9) 8
th to 10th Gen, 4 or more GHz Series Processor
Hard disk 3 x 480 GB or more SATA, NVMe, SSD or SAS 15K rpm with data striping
through RAID X (Mixed drive types allowed matching type/speed/capacity)
DVD-ROM DVD+/-RW
RAID/Internal Controller PERC H(x)
Memory From 32 GB up to 128 GB DIMM/LRDIMM/RDIMM
Screen/Video adapter 17″ Flat Panel with integrated video card with 1GB or more
Backup streamer Digital tape streamer with the same capacity as the total disk space
NIC 1 or more network card(s) supported by the network installed with capacity of
100/1000 Mbps for best performance
Computer in general If the server is a stand-alone computer, it could be a tower model or suitable
for placement in a rack. Both, with a scalable internal capacity and flexibility to
adapt to changing workload conditions. Local technical support is strongly
recommended.
1 Any 100% Intel compatible processor, such as AMD can be used as well, given that they deliver equal or better
performance.
6 | Hardware, Software and Training Requirements for DMFAS 6


A P P L I C A T I O N S E R V E R
application
servers. As such, there are no specific requirements on the hardware platform other than those of the
Web application server software itself. The following server configuration is based on a Windows
2012/2016 or Unix/Linux servers functioning as an application server only. Additional memory and
disk space might be needed if other software is installed (e.g. database or other applications running on
the same application server).
It is recommended to have an automatic detection software for monitoring updates and proactive
support notifications.
Hardware specifications for servers running another network operating system should have equal
performance and capacity.
Component Specifications
CPU2 Intel® / Core i(7/9) 8th to10th Gen, 4 or more GHz Series Processor
Hard disk 3 x 480 GB or more SATA, NVMe, SSD or SAS 15K rpm with data striping
through RAID X (Mixed drive types allowed matching type/speed/capacity)
DVD-ROM DVD+/-RW
RAID/Internal Controller PERC H(x)
Memory From 32 GB up to 128 GB DIMM/LRDIMM/RDIMM
Screen/Video adapter 17″ Flat Panel with integrated video card with 1GB or more
Backup streamer Digital tape streamer with the same capacity as the total disk space
NIC 1 or more network card(s) supported by the network installed with capacity of
100/1000 Mbps for best performance
Computer in general If the server is a stand-alone computer, it could be a tower model or suitable
for placement in a rack. Both, with a scalable internal capacity and flexibility
to adapt to changing workload conditions. Local technical support is strongly
recommended.
2 Any 100% Intel compatible processor, such as AMD can be used as well, given that they deliver equal or better
performance.
Hardware, Software and Training Requirements for DMFAS 6 | 7


W O R K S T A T I O N S ( D E S K T O P S / L A P T O P S )
The following table indicates the workstation requirements. T Specifications
components for running DMFAS effectively.
Component Specifications
CPU3
Intel® / Core i(7/9) 4-10 Core, 8
th to 10th Gen, 4 GHz or more
Hard disk 500 GB or more SATA/SSD 7.2 rpm
DVD+/-RW 16 speed or faster
Memory 8 GB or more DDR4 DIMM or UDIMM
Screen/Video adapter 1GB RAM or more, 17/19” Flat Panel
1280*1024 or more VGA/DVI
NIC Network card supported by the network installed
1/10GB bps or more for best performance
PC in general Plug and Play ready (Windows 10 or Mac not using Safari), Flash BIOS,
local service available
3 Any 100% Intel compatible processor, such as AMD can be used as well, given that they deliver equal or better
performance.
8 | Hardware, Software and Training Requirements for DMFAS 6
P R I N T E R


Component Specifications
Type OS compatible laser printer
Format4 A4 (210 mm x 297 mm), duplex printing and A3
Language PCL6e or newer and Postscript
Capacity 12 – 16 ppm
Resolution 600 dpi
A C C E S S O R I E S
Component Description
UPS For the servers (and, if necessary, for the workstations)
Hub or, even better, a switch For connecting the server, workstations and printer
If 1/10GB network cards are used, check that the hub also supports 10GB.
Backup Media For the streamer(s)
The number of digital disks is dependent on the back-up strategy.
Cartridges For the printers
Paper For the printers
4 All standard DMFAS 6 reports fit on A4 paper (210 mm x 297 mm) in portrait or landscape orientation. For country-specific
or customized reports, a printer with a capacity for larger paper sizes provides more flexibility.
Hardware, Software and Training Requirements for DMFAS 6 | 9
Software requirements
S E R V E R S O F T W A R E
N e t w o r k o p e r a t i n g s y s t e m
For the database server, any network operating system that supports the Oracle RDBMS (relational
database management system) version is accepted. The expertise for administering and maintaining the
network should already exist at the installation site. Up to now, the Oracle DMFAS 6 database has been
installed and tested under Windows 2012 and 2016 (64 bits), Linux and UNIX. The DMFAS Programme
in Geneva uses Windows 2012/2016 server as reference platform.
Oracle Release Operating System
11gRx 12cRx MS WS 2012 SP2 MS WS 2016 Linux/Unix/Solaris/AIX
x stands for Release 1 or 2
The DMFAS programme certifies the platforms MS WS 2012, 2016 and Linux Centos 7 as operating
systems. For any other operating system, you must contact the DMFAS Programme for more
information.
install an antivirus and malware protection software.
O r a c l e d a t a b a s e s o f t w a r e
DMFAS 6 is targeted for platforms using the Oracle RDBMS version 11gR2 or 12cRx. In line with this,
two RDBMS products are available: Standard Edition 2 or Enterprise Edition. So far, the product that
we recommend buying for a new installation or for an upgrade from a previous DMFAS installation is
Oracle 12cRx Standard Edition 2 because of its favourable price. The Enterprise Edition would be
suitable for installations supporting 25 users or more and/or when specific features of the product are
needed to comply with specific requirements.
A p p l i c a t i o n s e r v e r s o f t w a r e
DMFAS 6 is targeted for platforms using any of the following application servers:

  • Apache Tomcat V7 (open source, free to use)
  • JDK 6 or 7
    S O F T W A R E F O R W O R K S T A T I O N S
    O p e r a t i n g s y s t e m
    DMFAS 6 runs as any standard Internet application, making use of current market standard web
    browser software, supporting the actual Java programming standards (CSS2, AJAX, Java & JavaScript);
    and including the support for multilanguage character sets (considering that the system needs to
    support English, French, Spanish, Russian and Arabic5
    character sets) as Internet Explorer 11, Mozilla
    Firefox or Chrome. In line with this, there should not be restrictions in terms of operating system (MS
    Windows 10/Mac/Linux) as long as it provides support for the above-mentioned features.
    install an antivirus and malware protection software.
    5 For the Arabic interface the system must also consider the data entry from right to left and the inversion of data entry
    forms.
    10 | Hardware, Software and Training Requirements for DMFAS 6
    R e p o r t i n g s o f t w a r e f o r D M F A S c l i e n t s
    Considering the change of technology, the DMFAS 6 software makes use (internally) of the open source
    Business Intelligence and Reporting Tool named Eclipse BIRT, which provides a more professional set
    of reporting features (e.g. the possibility to produce graphs, exporting to Portable Document Format,
    etc.). This open source software can be additionally installed with DMFAS version 6.
    Under the terms and conditions of any open source tool, Eclipse BIRT installation is allowed on any
    DMFAS client to create reports. However, it is advisable to install it on the computer of a technical or
    advanced functional user in order to prepare the set of reports required by the debt office. These reports
    can be later centralized on the application server and executed from any DMFAS client.
    Note that to continue using any Oracle reporting tool, a license fee is required whereas for the use of
    BIRT no license fee is required.
    A d d i t i o n a l s o f t w a r e f o r w o r k s t a t i o n s
    The following additional products are needed to integrate the DMFAS 6 software with reporting tools:
    • Adobe Acrobat Reader (TM) (may be required for viewing/printing reports)
    • Office tools (spreadsheets, word processors, etc.)
    • Java SE (JDK or JRE) 6 or 7
    P R I C E S A N D L I C E N S I N G
    The following table details the Oracle products needed to run DMFAS 6 and their respective prices as
    indicated on the Oracle web site. Prices are based on the latest price list of Oracle products for the
    Oracle 12cRx database.
    P r i c e o f O r a c l e p r o d u c t s
    The prices below may vary subject to changes in the marketing policy of Oracle Corporation.
    Product Price
    (for a perpetual licence) Maintenance per year
    Oracle12cR2 Standard Edition
    2 (servers up to 2 sockets and
    4 core processors)
    6
    5 users minimum: 1,750 USD
    (Named User Plus: 350 USD)
    OR
    Per processor: 17,500 USD
    5 users minimum: 385 USD
    (Named User Plus: 77 USD)
    Per processor: 3,850 USD
    6
    Institutions having servers with more than 4 processors will have to acquire Oracle Standard Edition 2 and the price may
    vary according to the number of processors. Please contact the DMFAS Programme or your local Oracle dealers.
    Hardware, Software and Training Requirements for DMFAS 6 | 11
    Example
    The following example is for 1 server at the Ministry of Finance or Central Bank with 1 processor and 5
    DMFAS users (with perpetual licenses).
    Product Price
    1 Oracle Database 12cR2 Standard Edition 2
    1 year of maintenance
    (350 USD x 5 NU) = 1,750 USD
    (77 USD x 5 NU) = 385 USD
    Total Licenses 2,135 USD
    . As an example, one institution with
    25 users or more accessing one Oracle database should acquire
    institution with only five users accessing one Oracle database should acquire one per
    Named User Plus
    H a r d w a r e w a r r a n t y a n d O r a c l e m a i n t e n a n c e a g r e e m e n t s
    All critical hardware and software should be covered by a warranty or maintenance agreement (also
    known as a service agreement).
    All hardware components and software are acquired under a warranty for a period during which their
    repair or replacement is the responsibility of the supplier, so long as defects occur during normal use.
    You usually have the option of extending the warranty when you buy a product, especially with larger
    hardware items.
    For every Oracle product license bought, it is recommended to obtain an annual maintenance
    agreement. Depending on the type of maintenance support purchased, this agreement may cover
    hotline telephone support or web support (Metalink). In addition, a maintenance agreement
    automatically gives the right to a free upgrade of the Oracle product.
    12 | Hardware, Software and Training Requirements for DMFAS 6
    Training requirements
    It is the policy of the DMFAS Programme that the DMFAS software should be installed on an
    intranet/internet. Consequently, the following information focuses on other recommended training
    activities that should be carried out before DMFAS 6 software is installed. Normally, training activities
    of this type are conducted locally by a software vendor, technical institute, etc. The suggested training
    modules are:
  1. Training in Oracle database administration – The training component would concern only one
    or two selected staff members who would be responsible for the database administration part
    of the DMFAS 6 installation. This training should at least include i) Oracle database installation
    and upgrade ii) the physical structure of an Oracle RDBMS and iii) the administration and
    tuning of an Oracle database.
  2. Training in application server administration – The training component would concern only
    one or two selected staff members who would be responsible for the maintenance and
    administration of the application server selected for the DMFAS 6 installation. This training,
    building on the above-mentioned training, should at least include i) the physical structure of
    the application server components, and ii) the administration and maintenance of the
    application server itself.
    Finally, it is worth mentioning that, normally, during DMFAS 6 technical training, many relevant
    database administration tasks will also be carried out by UNCTAD after the system installation

Leave a Comment