Database Server Sizing - Intergraph Smart 3D - Release Bulletin

Intergraph Smart 3D Release Bulletin

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Release Bulletin
Version_S3D
12.x(2018)

With Smart 3D, 64-bit servers are required. The 64-bit versions of Microsoft SQL Server and Oracle run on the 64-bit version of Microsoft Windows Server.

For large projects, we recommend having a database server that is dedicated to Smart 3D and runs only one project. For medium and small projects, several projects can be run on the same database server. However, having multiple projects on the same server increases the server requirements. When sharing several projects, add additional hard drives and increase the memory and CPUs. Another important performance feature for servers is to have dual network cards. Also consider the impact of sharing on your network. The network latency between the client and the database server should be less than 1ms on a gigabyte network.

Server Specifications

Project size

Small

Medium

Large

Number of processor cores

4

4-8

8 or more

Memory for Microsoft SQL Server and Oracle

32 GB

64 GB

128+ GB

Bus Size, OS, and Database

64-bit

64-bit

64-bit

The type of memory has a limited impact on the overall performance.

  • Oracle 12c Standard Edition 2 only supports setups of up to two sockets and 16 threads.

  • Running a Microsoft SQL Server or Oracle database on an Itanium processor-based server has not been certified and should not be done.

Hard Drives

Distribute files across several disk drives on the server. Each drive does not need a large capacity. The speed of the drive is important, so use 15K RPM or faster.

Project with SQL Server

The following example shows a configuration for a project using Microsoft SQL Server. The minimum distribution is four physical drives to separate the data files to increase the I/O band operation performance.

C: Drive

Operating system

D: Drive

SQL Server software

E: Drive

Database data files (.mdf files)

F: Drive

Database log files (.ldf files)

Project with Oracle

The following example shows a configuration for a project using Oracle Server running on 64-bit. The minimum distribution is five physical drives to separate the data files to increase the I/O band operation performance.

C: Drive

Operating system

D: Drive

Oracle software

E: Drive

Database data files

F: Drive

Database index files

G: Drive

Database redo files