Before upgrading to the latest version of manexSQL, it is important to have your system prepared and all hardware and software requirements met. Meeting system requirements before the installation process helps to ensure that you can begin using manexSQL as soon as possible. Once your hardware and software are in line with the standards below, the installation process may begin.
Server Recommendations for Physical or Virtual Server | |
Operating System | Windows 2019 is recommended as a minimum for the database and/or web server. If more than fifteen workstations will be using manexSQL concurrently, it is recommended that a separate server be used for the web application and database server that houses the SQL databases. (This is to reduce latency issues.) Terminal services may also be set up to reduce the load on the main Windows server that has SQL services installed. |
Processor | 3.60 GHz or higher is recommended for the processor. A more powerful processor protects against near future obsolescence.
It is recommended that this server be dedicated to manexSQL use only in order to maintain the highest level of performance. |
Main Memory | 64 GB of RAM or higher is recommended.
SQL Server will allocate as much RAM as is needed to cache the data. Depending on the size of the database (or how many databases are being utilized at any given time), these numbers may change.
It is recommended that RAM usage by SQL be monitored after initial setup and adjusted accordingly.
The minimum recommendations are based on 10 users. For every increment of 5 users, it is recommended that 2-4 GB of RAM be added. |
SSD/Hard Disk | SQL Server 2019 requires 6-8 GB of available hard disk space to install. Keep in mind that there must also be enough room for the database and to allow for future expansion.
A minimum of 1 terabyte of available disk space on the server is recommended.
SSDs are recommended for performance purposes. (SSD read speed is about four times faster than that of HDD.) |
Network Requirements | A minimum of 10 MB network speed per user is recommended. Network should be no more than three layers.
A permanent internet/intranet connection to the web server is required in order to access manexSQL. |
Client/User Computer | |
Operating System | Windows 10 or higher is recommended. |
Processor | The most powerful processor within budget is recommended in order to protect against future obsolescence. |
Main Memory | 16 GB or higher is recommended. |
SSD/Hard Disk | It is recommended that SSD be mixed with the hard disk to improve performance. |
Web Browsers | Chromium-based browser Firefox Safari (macOS) |
Barcode Readers | ||
Both 1D and 2D barcodes are available for use in manexSQL. When purchasing readers, consider which type of barcode you would like to be using. You may wish to consider a reader that possesses both 1D and 2D scanning capability. | Reader Brand | Reader Model |
Symbol | DS6708 | |
Symbol | DS4308 | |
Honeywell | 1900 | |
Zebra | DS6708 | |
Koolertron | GH-BT (2D wireless bluetooth) | |
Label Printers | ||
Roll labels were created and designed within the system using a Zebra/LP2844.
It has been confirmed from clients that the following other makes and models also function with these labels: | Reader Brand | Reader Model |
Zebra | LP 2844 | |
Zebra | ZP450 | |
Zebra | ZP505 | |
Zebra | GK420T | |
Zebra | 110XiIII | |
Zebra | ZM400 | |
Zebra | Z4M | |
Brady | IP300 | |
Microsoft Software Requirements for SQL Server | |
Windows PowerShell | Windows PowerShell 2.0 or higher is required for installation of database engine components and SQL Server Management Studio. If it is not detected during installation, it will need to be installed. |
For more detailed descriptions for installing Windows SQL Server, please see the SQL Server Documentation page on the Microsoft website.
Microsoft SQL Server Memory Settings and Performance
SQL Server is designed to use all memory the system has available. While this is fine for systems that are dedicated to running only SQL Server, it can cause performance issues with systems that need to run other applications. As a result, it is recommended that a dedicated server be used to run the SQL Server system. If the server is used to run multiple applications, performance issues could occur.
If it is not possible to have a dedicated SQL system, SQL Server allows users to change the server memory configurations. This allows users to modify their SQL Server to use only as much memory as is desired, leaving enough for any other tasks that may need to be performed. It is still recommended that a dedicated server be used for SQL Server, as changing memory configurations could cause performance issues.
For more information about SQL Server memory settings and how to set up the SQL Server memory configuration, please visit Server Memory Configuration Options.
Database Software Requirements | |
Microsoft SQL Installation and Setup | SQL Server Manager 2019 or higher is recommended. It is also recommended that the SQL Server instance is dedicated to manexSQL only in order to ensure optimal performance. If a dedicated SQL Server instance is not possible, please see SQL Server Memory Settings and Performance for options.
SQL Express versions may be used, but there are limitations regarding database size and number of users. IT/database administration staff will need to determine what actual hardware requirements will be needed to ensure adequate room for future growth and development. |