Specification for mSQL: mSQL has been designed for use on Microsoft Windows-based systems running Microsoft SQL Server (2008* and later). To get the best performance you need to match the hardware to the volume of data that you need to process. For small databases where performance isn’t likely to be an issue, we would normally recommend a standard desktop machine. For larger databases you should consider upgrading the hardware according to the recommendations below. mSQL is integrated into SQL Server so the key technical requirements relate specifically to those requirements that are required to run SQL Server itself. We have identified the main areas which affect the software’s performance below.
*newer versions will be dropping support for SQL Server 2005
**Also note the .net Framework 3.5 is required for install - this is not included by default with newer windows server versions - you need to add it via the server roles and features and need an install image available to add it.
Processor Speed: The processor or CPU frequency (typically measured in GHz) influences the rate at which information can be processed. The higher the CPU speed, the faster the processing. mSQL is a multi-threaded application and will deliver a significant increase in performance if your computer has multiple CPUs and/or cores.
Hard Disk Speed: The faster the hard disk the better. Depending upon data volumes and available RAM, mSQL and SQL Server can be disk intensive processes, and so the rate with which the data can be read from and written to the hard disk can be a critical factor. For traditional hard drives, the higher the drives speed (RPM) and cache (MB), the greater the data transfer rate.
A SCSI interface will further increase the transfer rate from the disk and so is beneficial especially when processing large volumes of information, although ATA is sufficient for the great majority of organizations. Where performance is a priority we recommend using Solid State Drives (SSDs) and in particular the PCIe SSD drives wherever possible, as these are capable of significantly faster data access rates.
RAM: Having sufficient RAM is vital for mSQL to process data at optimum speeds; having too little will create a bottleneck within the computer that could result in dramatically decreased performance, particularly with large data volumes where SQL Server will be constantly reading data from the disk.
We strongly recommend at least 8GB of RAM for small- and medium-sized jobs, but for larger jobs (in excess of 10 million records) a minimum of 16GB of RAM is preferable.
Network: If you are running mSQL on one computer with your main database located on a different computer, then it is likely to run more slowly than if mSQL and the database were located on one computer. As mSQL is integrated into SQL Server, for optimum performance we would recommend having mSQL installed on the same computer as your database.
Operating System: mSQL is compatible with Microsoft Windows 2012+/7/8/10 operating systems, and Microsoft SQL Server 2008 or later. We strongly recommend using a fully up-to-date and patched operating system, as this will benefit mSQL in terms of robustness, stability, and security.
- Microsoft Windows XP
- 1GB of free RAM (not recommended however)
- 1GB of free disk space (8 gigs if also licensing optional addressing module)
- .net 3.5 Framework
Please also refer to Microsoft SQL Server Hardware requirements:
- Microsoft Windows Server 2012 or Microsoft Windows 10 or Newer
- Intel Xeon 3GHz CPU, or equivalent, with 8 or more cores
- 8GB RAM (small/medium databases) 16GB+ RAM (large databases)
- 2 SSD Hard Drives