Editing System Requirements
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 20: | Line 20: | ||
*Memory/RAM: Ram requirement is a factor of the database size. Plan on 1 gig per gig of database size plus 4-gig | *Memory/RAM: Ram requirement is a factor of the database size. Plan on 1 gig per gig of database size plus 4-gig | ||
minimum for operating system use. If hosting other applications on the SQL server you will need to reserve memory for | minimum for operating system use. If hosting other applications on the SQL server you will need to reserve memory for | ||
| − | |||
*Go to this article for details for improving SQL Performance | *Go to this article for details for improving SQL Performance | ||
| − | *MS SQL should not be installed on a domain controller due to security considerations and domain controller default | + | *MS SQL should not be installed on a domain controller due to security considerations and domain controller default SQL databases (Note: As of SQL 2017 Microsoft will no longer allow the installation of SQL on a domain controller). |
| − | SQL databases (Note: As of SQL 2017 Microsoft will no longer allow the installation of SQL on a domain controller). | ||
| − | *MS SQL version should be matched to server operating system 2012 – SQL 2012 R2 SQL 2014 - SQL 2014 R2, | + | *MS SQL version should be matched to server operating system 2012 – SQL 2012 R2 SQL 2014 - SQL 2014 R2, Server 2016 – SQL 2017, etc. (Note: 2008 – SQL 2008 R2 is no longer supported by Microsoft and you should update your systems ASAP). |
| − | Server 2016 – SQL 2017, etc. (Note: 2008 – SQL 2008 R2 | ||
| − | and you should update your systems ASAP). | ||
| − | *Server should have a separate drive for SQL Temp database usage | + | *Server should have a separate drive for SQL Temp database usage as this database is written to often in high volume operations (SQL Performance) |
| − | written to often in high volume operations (SQL Performance) | ||
| − | *Minimum free hard disk space required: 4 GB minimum, 10 GB preferred | + | *Minimum free hard disk space required: 4 GB minimum, 10 GB preferred |
*Servers should be using a Raid 10 configuration with a separate drive for log files and temp database usage | *Servers should be using a Raid 10 configuration with a separate drive for log files and temp database usage | ||
| Line 42: | Line 37: | ||
*Minimum screen resolution: 1024 x 768 – SME is optimized for 1280 x 1200 | *Minimum screen resolution: 1024 x 768 – SME is optimized for 1280 x 1200 | ||
| − | *Network: 10Mbps min, 100Mbps or 1Gbps recommended | + | *Network: 10Mbps min, 100Mbps or 1Gbps recommended. |
| − | *Operating System: Windows 10, or Windows Server 2016, SQL 2016 | + | *Operating System: Windows 8/Win 8.1, Win 10, or Windows Server 2008 STD R2/2011 STD, 2012 R2 STD, SQL 2014, Server 2016, SQL 2016. (Note: any MS operating system prior to Windows 8.1 is no longer supported by Microsoft and its use should be discontinued immediately). |
| − | prior to Windows | ||
| − | *MS Does not recommend installing MS SQL Server on a domain controller or SBS operating system. We also do not | + | *MS Does not recommend installing MS SQL Server on a domain controller or SBS operating system. We also do not recommend installing on a server running MS Exchange Server. (Note: As of SQL 2017 this is no longer allowed in any manner by the SQL installer). |
| − | recommend installing on a server running MS Exchange Server. (Note: As of SQL 2017 this is no longer allowed in any | ||
| − | manner by the SQL installer). | ||
| − | *Database: MS SQL 2017 | + | *Database: MS SQL 2012, 2014, 2017, 2019 any edition. (Note: SQL 2008, 2008 R2 is no longer supported). |
*Note: The Express Edition is free and has no user limit, but does have the following limits: | *Note: The Express Edition is free and has no user limit, but does have the following limits: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | Database limit of 10GB for 2012 + | ||
| + | Limits processor cores to 1 | ||
| + | Memory usage to 4 gig (SQL 2017+ now combine some previously separated memory processes and may require significantly more memory than the posted limits). | ||
| + | This is sufficient size for most companies unless you plan utilizing stored documents. High5 suggests using a separate SQL instance for SME. We can share a SQL instance however certain maintenance tasks may take the other databases off-line while performing the maintenance | ||
*Express version are limited in memory usage, Database size, processor cores, and in basic optimization functions | *Express version are limited in memory usage, Database size, processor cores, and in basic optimization functions | ||
| − | *High5 follows Microsoft directives for lifecycle product support. | + | *High5 follows Microsoft directives for lifecycle product support. https://support.microsoft.com/en-us/lifecycle |
| + | *SQL Server 2005 – no longer supported | ||
| + | |||
| + | *SQL Server 2008 – no longer supported | ||
==System Requirements for Mobile SME Products== | ==System Requirements for Mobile SME Products== | ||
See [[SME Mobile Prerequisites]] for system requirements. | See [[SME Mobile Prerequisites]] for system requirements. | ||