Database

<< Click to Display Table of Contents >>

Navigation:  Technical Informations > Hardware and Software requirements V8.3 >

Database

Obervations :

 

NETIA products are compatible with the latest versions of Microsoft SQL databases still in support : SQL 2012, 2014, 2016 : see link below to check the Microsoft SQL end of support.

Server sizing may vary depending on the number of users and usage.

 

https://support.microsoft.com/fr-fr/lifecycle/search/1044

 

We advise you to doubling databases.

In terms of database redundancy, NETIA software is validated for use with the NETIA Dual Database System or the Microsoft Always On Failover Clustering High Availability System.

 

Hardware and requirements :

 

.NET Framework 4.6 for SQL 2016

Windows Powershell 2.0

 

SQL features to install :

-        Database engine and data files, full text search

-        Integration Services

-        Management Tools – Complete

-        SQL Server Data Tools

 

Processor, memory, disk and operating system :

 

 

Minimum

Recommended

Memory

8 GO DDR3

16 GO DDR4

Processor Frequency

3,8 Ghz

2,1 GHz

Processor type

Intel Xeon E3-1200 v6

Intel Xeon E5-2620 v4

Number of core/thread

4 Core/8 Threads

8 Core/16 Threads

Hard Disk speed

7200 Tr/min

10000 Tr/min

Disk space required for SQL installation

2 Go

10 Go

Disk space needed for databases

 

C:/ Operating System > 200 Go
D:/ Database > 200 Go
E:/ Backup > depending on RPO/RTO
F:/ TempDB (SSD or Fast Drives 10K ) > 100 Go
L:/ Transaction logs ( ldf files) > 200 Go
Q:/ Qorum (if we are on failover clustering)

Network

1000 BaseT

1000 BaseT

 

 

 

Operating sysytem

Windows Server 2012 R2

Windows Server 2016

Distribution / Partitioning of disks

C:/ Operating System
D:/ Database (mdf files)
L:/ Transaction logs (ldf files)

C:/ Operating System
D:/ Database (mdf files)
E:/ Backup
F:/ TempDB (SSD or Fast Drives 10K)
L:/ Transaction logs (ldf files)
Q:/ Qorum (if we are on failover clustering)

RAID type (except tempDB disk)

 

Raid 1
Raid 1+0

 

 

 

Virtualizable

Yes

Yes

 

 

 

Does not take into account possible functions

secure databases (merge / cluster …)