DRTrack requirements may vary depending on which software modules have been licensed for use, the number of licensed users, hosting setups, and the types of operating systems being used.  This article provides general system requirement information and may not apply to all situations or setups. 

 

The following is required to run each component as an individual server.


SQL Server (2008+) Operating System

  • Windows Server 2008+ (recommend 64 bit)
  • SS Management Studio
  • SS Reporting Services
  • SS Business Intelligence Development Studio (develop/deploy reports)
  • Mixed Mode
  • ID with Database and System Admin credentials for DRTrack database
  • Deploy read/write credentials for reporting services
  • Admin folder permissions for a DRTrack report repository in SSRS website
  • Port 1433 (or other) for database connectivity
  • TCP/Named Pipes enabled
  • Backup policy and procedures (mirroring, clusters, or other failover setups as directed by the user’s organization)
  • Enterprise versions of SQL Server (recommend 2008 Std+, 64-bit version)
  • Virtualization supported
  • 10/100/1000 connection to other servers, if a stand-alone instance

 

Drive Space Requirements

  • Operating System and Paging File:  expect ~20GB
  • Database Primary file, Log, and temp Database, Initial size:  250MB  (expected)
  • Database average growth of ~5MB per month per device (or per route)
  • GPS data is the primary growth factor; rates can vary between providers based on the number of points per hour returned; a range of 1 to 10 MB/month/device
  • Planned Route Data is secondary growth factor; a range of 1 to 2 MB/month/route
  • Recommend SCSI, SATA2, or SATA3 HD arrays
  • RAID 0, 1, or 10 for the primary data file  (RAID 5 not recommended)
  • Separate drives for primary data file, logs, and temp Database (better performance and speed)

 

Memory

  • Ensure Operating System and Database version support memory requirements
  • 1GB for Operating System (more is better)
  • 1 GB for normal Database operations (more is better)
  • Add ~2GB per 100 tracking devices
  • Add ~1GB or more for reporting load

 

Processor

  • Recommend Dual Quad-Core (or other multi-core processors)
  • 2 cores for Operating System and 2 for Database basic operations
  • Additional core per 50 trucks
  • Additional 1+ core for reporting services
  • More = better/faster