Versions Compared

Version Old Version 1 New Version 2
Changes made by

Mark Elkomos

Chris Kerr

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
QPD52:AboutQPD52:
About
nopaneltrue

Applies to All

...

Database Server

Minimum Hardware Requirements

4 CPU Cores

>16 GB RAM

>300 GB Hard drive space

Software Requirements

Microsoft SQL Server 2008R2 or later (see Note 4 Deprecation Notice below)

Sizing

Database sizing requirements vary depending on the volume of data.
As a guide an operation that has an annual output of 100,000 Work Orders, 150,000 Samples, 500,000 Tests/Inspections and 200,000 Test Reports will grow approximately 40 GB per annum. Almost 50% of this data is stored binary images (PDFs) of Test Reports. If these have been published to Construction Hive they can be purged from the database.

...

from the database.

SQL Server Version

Note

Deprecation Notice

From June 2023, the minimum supported SQL Server database compatibility level for new QEST Platform releases will be 130, requiring SQL Server 2016 or newer.

After June 2023, Spectra QEST support for QEST Platform on each SQL Server version will extend until that SQL Server version reaches the end of Extended Support from Microsoft. SQL Server 2016 SP3 will remain in Extended Support until July 14, 2026.

All customers should plan to upgrade to SQL Server 2016 SP3 or newer by June 2023.

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#FFEBE6

Caution

  1. For optimal performance, network latency must be minimized by keeping the database server and the application server(s) physically close.
    As a guideline, good performance requires latency near or below 1 millisecond between these servers. If possible, connect the database server and the application server(s) to the same switch.
    Care should be taken when designing a deployment in which one or more QEST Platform servers are virtualized. Please ensure that the physical hosts will remain proximate and that virtual switching does not add unacceptable latency overhead.

  2. SQL Server Express Edition may be used during implementation, but the severe limitations on database size and performance make it unsuitable for production use.
    As of the 2017 edition, SQL Server Express has the following limitations:

    • Maximum Number of CPU cores utilized: 4 cores

    • Maximum amount of RAM utilized: 1 GB

    • Maximum Database size: 10 GB

Info

Notes

  1. Microsoft support for Windows Server operates on a fixed life cycle. Versions prior to Windows Server 2016 are no longer in Mainstream Support and are not recommended

...

  1. for new implementations of QEST Platform.

Configuration and Licensing

...

Web Server

Minimum Hardware Requirements

4 CPU Cores (or vCPUs)

4 GB RAM

>1 GB free Hard Drive space

Software Requirements

Required:

Windows Server 2008 or later (64-bit) (see note 3 below)

.NET Framework version 4.6.2 or later (see note 1 below)

Internet Information Services (IIS) 7.0 or later with default features plus ASP.NET v4.5.

Internet Information Services extension URL Rewrite 2.1 or later.

Sizing

For the minimum hardware we estimate up to 1000 users can be supported with peak request rates of around 100/second.  This will scale up or out as required.

...

HTML Comment
hiddentrue

Screenshot Reference List

Screenshots on this page were sourced from the appropriate /wiki/spaces/DT/pages/591495178, details follow:

Environment:

References:

Insert excerpt
QPD52:Trademarks, Terms of Use and Privacy StatementQPD52:
Trademarks, Terms of Use and Privacy Statement
nopaneltrue