Database server

Database server hardware is selected based on the number of salespoints that are supported. If more than seventy-five salespoints are supported, special consulting services is used to determine the exact configuration for the network. In general, SQL Server must be dedicated to Salesware applications only and not used by other applications. Siriusware Inc. supports SQL Server 2012 and SQL Server 2008. For less than twenty salespoints, the middleware can be run on the database server. A backup strategy with the necessary hardware to support it are required. A battery backup system (UPS) capable of lasting at least forty-five minutes helps prevent a variety of potential database corruption problems. A DVD is highly recommended. Keeping your data on a separate drive system from your operating system helps to improve the speed of the database server. The minimum and recommended requirements call for SQL Server 2008 Standard Edition, 32-bit (and therefore a 32-bit operating system). Please consult Microsoft SQL Server requirements if using a different version, including the following links:

Number of salespoints¹	Component	Minimum − The minimum hardware requirements correspond to the minimum OS; other OSes require higher than minimum.	Recommended
Less than 20 salespoints	Operating system	Windows Server 2003	Windows Server 2012 with 64bit SQL Server 2014
	Processor	Dual core or better	Multi-core (4+)
	Free space on hard drive	100 GBytes per year of data. Ten years is the recommended length of time to plan for, so you have 1000 GByte of free space. Also, you have a separate drive system for holding backups with enough space for several full backups and differentials. Thus, if you have a 25 GByte database, you would need approximately 100 GByte of free space for backups. Most installations therefore require two separate drives systems, each with at least 100 GByte free. Approximately 40 GByte is normally required for the operating system.
	RAM	4 GByte	8+ GByte
	Video	1024 x 768	1280/1024 or larger
	Network	10 Mbit Ethernet	100\1000 Mbit Ethernet
20 - 49 salespoints	Operating system	Windows Server 2003	Windows Server 2012 with 64bit SQL Server 2014
	Processor	Dual-core or better	Multi-core
	Free space on hard drive	100 GByte per year of data. Ten years is the recommended length of time to plan for, so you have 1000 GByte of free space. 1000 GByte is recommended. Also, you have a separate drive system for holding backups with enough space for several full backups and differentials. Thus, if you have a 25 GByte database, you would need approximately 100 GByte of free space for backups. Most installations therefore require two separate drives systems, each with at least 100 GByte free. Approximately 40 GByte is normally required for the operating system.
	RAM	4 GByte	8 - 32 GByte
	Video	1024 x 768	1280 / 1024 or larger
	Network	10 Mbit Ethernet	100/1000 Mbit Ethernet
50 - 75 salespoints²	Operating system	32Bit Windows Server 2008 or newer with 32bit SQL Server 2005	Windows Server 2012 with 64bit SQL Server 2014
	Processor	Quad Core or better	Multi-core (8+ i.e., i7 or better)
	Free space on hard drive	100 GByte per year of data. Ten years is the recommended length of time to plan for, so you have 1000 GByte of free space. 1000 GByte is recommended. Also, you have a separate drive system for holding backups with enough space for several full backups and differentials. Thus, if you have a 25 GByte database, you would need approximately 100 GByte of free space for backups. Most installations therefore require two separate drives systems, each with at least 100 GByte free. Approximately 40 GByte is normally required for the operating system.
	RAM	4 GByte	8-32 GByte
	Video	1024 x 768	1280/1024 or larger
	Network	10 Mbit Ethernet	100/1000 Mbit Ethernet

¹ The numbers provided are for Classic salespoints. For sites that implement the E-Commerce module, you adjust your calculations to accommodate for the Sales Host utility. A good rule-of-thumb is that a Sales Host is equivalent to 1 – 5 Classic salespoints, depending on your application and load.

² With larger venues (over fifty salespoints), the specifications are increased. The server is an enterprise solution with a two-channel RAID controller and a RAID 1/5 split, dual-processors and 4 GByte RAM. High-speed drives (15K RPM) are recommended.