Application, API, and database server requirements

This topic covers all the hardware specifications and software requirements for server(s) running AssetTrack.

AssetTrack can run in either a single-server configuration with IIS and SQL Server on the same machine or on a multi-server configuration with IIS and SQL Server on separate machines. In addition, if your company has IIS or SQL Server clusters, AssetTrack can run in clustered configurations and can also be run on virtual servers if you are running a virtual server environment.

On this page:

Standard enterprise configuration (Two servers)

This is the standard recommended two-server configuration for production deployments of AssetTrack.

This configuration has baseline values to support up to 150,000 assets in an enterprise production setting. These settings can be adjusted upward for larger installations, or downward for smaller or non-production environments.

Server 1: AssetTrack Application and API Server

Component

Requirement

Processor

Minimum: 1 CPU core of any processor that meets requirements for Windows Server 2008, 2008 R2, 2012 and 2012 R2.

Recommended: 2 CPU cores.

Memory

Baseline: 8GB RAM

Per 100,000 assets, increase memory by 2GB.

Disk space

10GB of available hard disk space.

OS

Windows Server 2008 R2 
Windows Server 2012


All critical updates recommended.

Software

  • Internet Information Services (IIS) 7.0 - 8.5.
    • ASP.NET (role service)
    • Windows Security (role service)
  • Microsoft .NET Framework 3.5 SP1
  • Microsoft .NET Framework 4.5.2 (Required only if you plan to install the API server for use with iOS/Android/Blackberry/Windows Phone).
  • Optional: SSL certificate. We recommend using a certificate that is signed by a root certificate authority (e.g. Verisign, Thawte) because mobile devices sometimes have issues with self-signed or certificates from unknown certificate authorities.


Server 2: AssetTrack Database Server

Component

Requirement

Processor

Minimum: 1 CPU core of any processor that meets requirements for Windows Server 2008 - 2012.

Recommended: 2 CPU cores.

Memory

Baseline: 8GB RAM

Per 100,000 assets, increase memory by 1GB.

Disk space

Data file: 10GB
Log file: 5GB
Backups (30-day): 80GB

OS

Windows Server 2008 R2
Windows Server 2012

All critical updates recommended.

Software

Standard or Enterprise editions SQL Server:

  • SQL Server 2008 or
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014

Only the SQL Server core database engine is required. Optional components are not required (e.g. Integration Services, Reporting Services).

SQL Server
Settings

Collation: SQL_Latin1_General_CP1_CI_AI
Security mode: Mixed

Single server configuration

This is a configuration that is recommended for smaller (< 30,000 assets) departmental installations or test/staging environments that will not incur heavy concurrent use.

Component

Requirement

Processor

Minimum: 2 CPU cores of any processor that meets requirements for Windows Server 2008 or Windows Server 2012.

Memory

Baseline: 8GB RAM

Per 100,000 assets, increase memory by 1GB.

Disk space

50GB of available hard disk space.

OS

Windows Server 2008 R2
Windows Server 2012

Windows Server 2012 R2 

All critical updates recommended.

Software

  • Internet Information Services (IIS) 7.0 - 8.5.
    • ASP.NET (role service)
    • Windows Security (role service)
  • Microsoft .NET Framework 3.5 SP1
  • Microsoft .NET Framework 4.5.2 (Required only if you plan to install the API server for use with iOS/Android/Blackberry/Windows Phone).
  • Optional: SSL certificate. We recommend using a certificate that is signed by a root certificate authority (e.g. Verisign, Thawte) because mobile devices sometimes have issues with self-signed or certificates from unknown certificate authorities.
  • Standard or Enterprise editions SQL Server:

    • SQL Server 2008 or
    • SQL Server 2008 R2
    • SQL Server 2012
    • SQL Server 2014

    Only the SQL Server core database engine is required. Optional components are not required (e.g. Integration Services, Reporting Services).

Web farm configuration

Main article: Installing and configuring AssetTrack in a web farm

Both AssetTrack Server and its SQL Server can be configured in clustered configuration to increase availability and redundancy.   

 

Error rendering macro 'excerpt-include' : User 'null' does not have permission to view the page '_AMICopyright'.