Orange County NC Website
Browse       Search
HxGN OnCall® Dispatch Suite <br /> <br />6 <br /> <br /> <br />Database Storage Requirements <br />Hexagon's Safety, Infrastructure & Geospatial division has developed the following <br />hardware requirements with the best possible performance and safety in mind. These <br />requirements are intended to provide the required performance during a large incident. <br />HxGN OnCall Dispatch applications and their associated interfaces are database <br />write\read intensive (65% write\35% read). Hexagon recommends that these systems <br />(servers) are not shared with other common applications and that the servers be <br />dedicated to these applications. The most likely single point of bottleneck in a database <br />server is the IO sub-system. The focus with Hexagon's IO storage requirements is on the <br />performance more than on the disk space. <br /> Hexagon strongly encourages customers to use Solid State Drives (SSDs) on their <br />database servers. SSDs can provide significantly better performance than spinning <br />drives. <br />Consider how much historical data users want to keep on the live system when deciding <br />on disk space requirements. In particular, features such as attachments, GPS tracking <br />data, and external query results can increase the space requirements. Users may want to <br />place attachments, GPS tracking, and external query results onto separate disks since <br />these tables can become large. For Oracle and SQL Server, the tables are specifically <br />designed to be placed into separate tablespaces (Oracle) or filegroups (SQL Server) for <br />performance and storage. <br /> The size of your storage is dependent upon a couple of factors: <br /> Storing attachments, images, video, adorned event comments, and tracking <br />data in the database or a separate database <br /> How often data is archived <br />When using a SAN to support a virtual environment, Hexagon recommends SSDs be <br />used to meet the IOPs requirements. The ideal configuration would be a SAN that tiers <br />data, meaning that it places the most active data on the fastest drives and less used data <br />on slower drives. <br /> <br />Docusign Envelope ID: 463E937D-8F02-4D22-9EEA-B2B50627D9E0Docusign Envelope ID: DE681D27-7D55-4FB6-8C51-9394D26FBC9EDocusign Envelope ID: 295A5D15-51E9-4D4A-ABF7-42411BB309FA