The goal of this document is to provide detailed recommendations about what type of server configuration (hardware and software) is recommended by Aptora’s technical staff for running a Microsoft® SQL Server database engine; the backbone of Total Office Manager Enterprise Edition. This document is not intended to provide pricing or vendor recommendations.
Before looking at the Detailed Recommendations for a server system please review the General Server Requirements.
Aptora’s goal is to stay up-to-date with the latest technology. As new operating systems and servers become available we will strive to make our software compatible. We cannot recommend or guarantee support of newer versions before they are publicly available. We will post information about compatibility on our Web site as it becomes available.
Same as standard requirements.
Same as standard requirements.
| Specification | Minimum | Recommended |
|---|---|---|
| Operating System | Windows 2000 Professional (Some Service Packs may be required) |
Windows Server 2003 (Any Edition) |
| SQL Server 5 Users or Less |
SQL Server 2005 Express Edition† (Free) |
|
| SQL Server 6 Users or More |
SQL Server 2005 Express Edition†* (Free) | SQL Server 2005 Workgroup, Standard or Enterprise** |
| Processor (CPU) | One (1) Pentium III 1 GHz | Dual- or Quad-Core Server-Grade Processor |
| Hard Disk Space | 1 GB free | 20% or more of the total disk space |
| Total RAM / Allocated to ‘TOM’ Instance | 512 MB / 256 MB | 2 GB / 1 GB or more |
|
† Please read the SQL Server Express Limitations section of this document. * Having more than five users connected simultaneously could limit performance. ** Licensed editions of SQL Server can be purchased from most Microsoft resellers.
|
||
| Specification | Limit |
|---|---|
| Physical Processors (CPUs) | One (1) |
| Physical Memory (RAM) | One (1) GB Allocation to SQL Server |
| Database Size | Four (4) GB |
For systems being configured to run SQL Server, please use the system requirements available on Microsoft’s Web site at the following URLs:
http://www.microsoft.com/sql/editions/express/sysreqs.mspx
http://www.microsoft.com/sql/editions/workgroup/sysreqs.mspx
http://www.microsoft.com/sql/editions/standard/sysreqs.mspx
http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx
There are four main editions of SQL Server available from Microsoft. Below you will find information about what editions are recommended based on the planned configuration and use of TOM Enterprise Edition. Most companies will begin using TOM Enterprise Edition with SQL Server Express Edition, and will later upgrade to an edition with fewer limitations based on their needs at that time.
SQL Server Express Edition is recommended for companies that plan to have five or fewer simultaneous users in TOM Enterprise Edition. The database size and memory limitations of this SQL edition are not typically an issue with these types of configurations. If at anytime the limitations are exceeded an upgrade to a fully licensed copy of SQL Server will be needed to continue functioning with minimal or no performance constraints.
SQL Server Workgroup Edition is recommended for companies that plan to have six or more simultaneous users in TOM Enterprise Edition. The memory limitations of this edition are very reasonable, and there is no limit to the size of the SQL database.
SQL Server Standard and Enterprise Edition will typically not be needed for most companies that use TOM Enterprise for day-to-day operations. If the company plans to use SQL Server for operations other than TOM Enterprise (such as custom reporting using SQL Server’s Reporting Service, custom applications, etc.) then these editions of SQL Server can provide them with more configuration, expandability, and management options.
It is recommended that a Windows Server operating system be used for the TOM Enterprise Edition server. In general, operating systems that support the current version of SQL Server will support the TOM Enterprise Edition server components.
The following server configurations have been provided by Aptora’s IT Manager for consideration when purchasing a new server.
Dual Core Intel® Xeon® 3040, 2MB Cache, 1.86GHz, 1066MHz FSB
2GB DDR2, 667MHz
Microsoft® Small Business Server 2003 R2 with SP2, Standard Edition
250 GB SATA II HDD
RAID 1 Array
Operating System Partition of 25 GB or more
Quad Core Intel® Xeon® E5335; 2X4MB Cache, 2.0GHz, 1333MHZ FSB
4GB DDR2, 800MHz
Windows Server® 2003 R2, Standard x64 Edition with SP2
Dual Gigabit Network Adapters
320 GB SATA II HDD
RAID 5 Array
Operating System Partition of 50 GB or more
Intel and Xeon are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
Receive a FREE issue of Contractor Success, our full-color catalog.
You can also sign up for our Tech Tips Newsletters.
| TESTIMONIALS |
|