...
Note: For more information on Microsoft software requirements, see Microsoft Operating Systems and Microsoft Office Suites.
Category | Minimum Requirements | Recommended Requirements |
|---|---|---|
Brands | Insula Software recommends quality name brand server equipment that is fully tested and certified as compatible with Microsoft operating systems and associated products. Suppliers of these products (HP, Dell, etc.) offer on-site support assistance, which should also be considered. | |
Purpose | Should be a dedicated database/file server NOT responsible for PDC (Primary Domain Controller), authentication, mail, or other processor/disk/network intensive applications. | |
CPU Performance |
|
|
RAM | Minimum 1GB, 200MB permanently allocated to Microsoft SQL Server cache. Optimum cache performance is achieved when allocated RAM is equal to total data size. | Minimum 1GB, 200MB permanently allocated to Microsoft SQL Server cache. Optimum cache performance is achieved when allocated RAM is equal to total data size. |
HDD | 1GB for data, setup, and shared network files. | 1GB for data, setup, and shared network files. |
Video | VGA or higher resolution at least 1,024x768 pixel resolution. | VGA or higher resolution at least 1,024x768 pixel resolution. |
Performance | High performance hardware (BUS, HDD, etc.) is recommended as standard. | High performance hardware (BUS, HDD, etc.) is recommended as standard. |
Redundancy | Standard server redundancy techniques should also be employed, including redundant power supplies, RAID 5 (or better) HDD configurations, a UPS (Uninterrupted Power Supply) solution, and established on-site support contracts to ensure continuity of server availability should problems arise. | |
...
Note: For more information on Microsoft software requirements, see Microsoft Operating Systems and Microsoft Office Suites.
Category | Minimum Requirements | Recommended Requirements |
|---|---|---|
Brands | Insula Software recommends quality name brand equipment that is fully tested and certified as compatible with Microsoft operating systems and associated products. Suppliers of these products (HP, Dell, etc.) offer on-site support assistance, which should also be considered. | |
CPU Performance |
|
|
RAM | 512 MB | 1 GB |
HDD | 300 MB | 300 MB |
Video | 1024 x 768 Resolution, 32-Bit Colour Depth | 1024 x 768 Resolution, 32-Bit Colour Depth |
Performance | High performance hardware (BUS, HDD, etc.) is recommended as standard. | High performance hardware (BUS, HDD, etc.) is recommended as standard. |
Redundancy | Established on-site support contracts to ensure continuity of workstation availability should problems arise. No ongoing data is saved to client workstations. As a result, specific backup measures for workstations are not required. | |
...
- You may already have licences for Microsoft SQL Server (e.g., Small Business Server).
- Small sites with basic server hardware and few users can be eligible to free database licences by using the Express Edition of Microsoft SQL Server (subject to the Microsoft SQL Server Version Comparison).
- Larger sites should consider the correct edition of a database management system to suit the hardware infrastructure, size of data, number of users, and other factors in their environment.
...