1.1 Digizuite™ DAM supports the following versions of Microsoft SQL Server.
- Microsoft SQL Server 2012
- Microsoft SQL Server 2014
1.2 Operating System:
- Windows 2008 R2 Server
- Windows 2012 R2 Server
1.3 Processor type:
- Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
1.4 Processor speed:
- Minimum: 1.4 GHz
- Recommended: 2.0 GHz or faster
1.5 Memory:
- Minimum:4 GB
- Recommended: 16 GB or more
1.6 Disk layout:
For production systems with physical disks, we recommend using SSD or fast SAS, and use appropriate redundancy on a hardware level.
- Disk 1: OS/SQL Binaries
- Disk 2: System databases (except tempdb)
- Disk 3: tempdb (or RAM disk)
- Disk 4: User databases
- Disk 5: User DB transaction logs
Note: For virtualization, please consult your vendor for recommendations about Microsoft SQL server, especially about IO optimizations.
High Availability mode recommendations for Microsoft SQL.
Use this version of Microsoft SQL Server:
- Microsoft SQL Server 2012
We recommend using the "AlwaysOn Availability Groups" feature, for a high-availability and disaster-recovery solution.
We recommend using the Asynchronous-commit mode, for maximum performance, and manual failover.
Since this not provided as a standard deployment option in the Digizuite DAM™ Center, we recommend using our consultancy for help in planning and deploying a HA solution.
Database mirroring is another feature for HA, but is being depreciated in future versions and Microsoft recommends using AllwaysOn. If mirroring is used, also configure this for asynchronous mode.
Table of Contents