What do I need to help get JusticeTM up and running?
In short, the minimum requirements to run the Justice system are:
Discussion of minimum requirements and possible alternatives:
- SQL Server 2012, 2008, Or 2008 Express (Standard or Professional Edition).
- SQL Server licenses for all client machines accessing data on the server.
- Windows Server, operating in a client-server environment.
- Microsoft Office2000 or later installed (professional edition) on each workstation.
• SQL Server is the database engine needed for the Justice system. Justice applications work nicely with the Professional Edition of SQL Server. However, the Standard Edition is much cheaper and adequate for most departments. The Enterprise Edition is not necessary. It offers support for up to 32 processors on a single machine, can utilize up to 64GB of Random Access Memory (RAM), and provides for clustering support to distribute the load among multiple servers.
Server Licensing Options
• SQL Server is generally available under two licensing options: -Processor License. It requires a single license for each CPU in the computer running SQL Server. This license includes unlimited client device access. Server/Per-Seat Client Access License (CAL), requires a license for the computer running the Microsoft server product, as well as Client Access Licenses (CALs) for each client device. A set number of CALs is included (usually 5) with a server license and the server software. Justice doesn't require a CAL for every workstation, because Justice only accesses the SQL database for a fraction of a second and then closes the connection. For more information on licensing/pricing, go to http://www.microsoft.com/sql/howtobuy/pricing/
• JusticeTM software is licensed on a per terminal basis from Custom Micro Inc. at the time of installation. Additional terminal licenses can be purchased at any time in the future.
SQL Server Databases are designed to work with Windows Servers. There has to be at least one Windows based Server to host the SQL Server.
• SQL Server 2012 Enterprise Edition and Standard Edition run on Microsoft Windows® Servers, Windows 2000 Advanced Server, Windows 2000 Data Center Server operating systems, Microsoft Windows NT® Server with version 4.0 Service Pack 5 (SP5) or later, and Windows NT Server 4.0 Enterprise Edition with SP5 or later. WindowsXP and Windows7&8 are good environments for workstation terminals. NOTE: Justice will operate on 32 or 64 bit processors and operating systems.
• A copy of Microsoft Access 2000 or later is required to be installed on any workstation that needs to run reports from the Justice system. MSAccess is the preferred reporting tool for CMI's products because it's widely available, allows conversion of reports utilized by current customers, and has local training available for end users.
• In order for CMI's SQL based software systems to function satisfactorily, a properly operating network, including proper hardware and software components are required. Your agency's NT or Windows Server network needs be operating properly and have Microsoft SQL Server software installed prior to our arrival. We will install the SQL Server software if desired, however, Microsoft Office software including MSAccess should be installed prior to our arrival.
• When multiple server CPU's are available, a separate CPU and 1GB (Giga Byte) of dedicated RAM for the SQL Server software itself will greatly enhance performance. Servers with software capable of RAID level 5 will provide the best level of fault tolerance. The term RAID is an acronym for Redundant Array of Inexpensive Disks. Basically it involves having your data stored on multiple disks in a manner such that if you lost one hard disk, the others would still perform, but at a reduced speed for data retrieval. In other words, the network would slow down maybe 20-30%, but the data would still be retrievable. When the bad disk is replaced everything would come back up to full speed. It's a hardware issue that you should discuss along with pricing from your hardware vendor. If you can live without access to your data for a day or two when your hard disk dies, it might not be worth the price. It's not a question of WILL your hard disk crash, but WHEN.
• Work stations should be 600MHz or higher with as much RAM as possible.
• Video adapter cards capable of 1024 x 768 True Color resolution (32 bit) will provide the best video display. NOTE: Monitors with 800x600 resolution work, but leave much to be desired. Monitors with lower resolution are not supported.
• An external word processor is not necessary for Justice narratives. However, Word comes in very handy if the extended features of a dedicated word processor are desired, or required for special high profile cases. Justice handles all text processing internally. Spell checking and a thesaurus are available within Justice.