SQL Server (2019 Express) Operating System

  • Windows Server 2016, 64-bit
  • SS Management Studio (SSMS)
  • SS Data Tools (Business Intelligence) (SSDT)
  • Visual Studio 2017
  • 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 users' organization)
  • Enterprise versions of SQL Server (2019 Express, 64-bit)
  • Virtualization supported
  • 10/100/1000 connection to other servers if standalone instance

  

Drive Space Requirements

  1. Operating System and Paging File: expect 20+ GB

  2. Database Primary file, Log, and temp Database, Initial size: 250 MB (expected)
  3. Database average growth of 5 MB per month per device (or per route)
  4. GPS data is primary growth factor; rates can vary between providers based on number of points per hour returned; range of 1 to 10+ MB/month/device
  5. Planned Route Data is secondary growth factor; range of 1 to 2+ MB/month/route
  6. Recommend SCSI, SATA2, or SATA3 HD arrays
  7. RAID 0, 1, or 10 for primary data file (RAID 5 not recommended)
  8. Separate drives for primary data files, logs, and temp Database (better performance and speed)

 

Memory

  • Ensure operating system and database version support memory requirements
  • 1+ GB for operating system (more is better)
  • 1+ GB for normal database operations (more is better)
  • Add 2+ GB per 100 tracking devices; add 1+ GB 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
  • Add 1+ core per 50 trucks, and 1+ core for reporting services