| |
SQL SERVER up to 50 users |
MIDDLE TIER |
hardware |
• dual processors |
• 8 GB RAM |
•RAID 5 - 10k RPM disk no larger than 70/75 GB • optional: OS on separate RAID 1 disk |
|
•Single processor quad-core |
•4GB RAM |
•2 RAID 1 36 GB disks |
Blade server is a good option for agencies with high number of users |
1 Middle Tier x 100 users |
|
software |
•Windows Server 2008 R2 Enterprise Edition (supported Windows Server 2003 SP2 plus patches and Windows Server 2008 SP1 up to March 31 2010) |
•SQL Server 2008 SP1 Enterprise Edition (Supported SQL 2005 until December 31 2009 - MSCLink build 75, IBIS v2 and SalesLink require SQL Server 2008 EE SP1) DTC Services must be turned on |
All security patches MUST always be applied but only after checking with your support center. |
|
•Windows Server 2008 R2 Standard (supported Windows Server 2003 Standard SP2 plus patches Standard and Windows Server 2008 SP1 up to March 31 2010) |
• SQL Server connectivity only |
• MSMQ Client, MSXML4 Sp2 |
• .NET Framework V 1.1.4 or higher |
.NET Framework V 1.1.4 or higher Windows Server requires enabling of network DTC |
1 DBLink x 100 users with a minimum of 2 running on different PC. |
|
| |
SQL SERVER over 50 users |
|
hardware |
• 4 multi-core processors |
• 32 GB RAM minimum |
• RAID 1 for OS, 15k RPM 36 GB Disk |
• RAID 10 for transactional DBs 15k RPM 70/75 GB Disk |
• RAID 5 for DBChangLog archived - up to 150 GB 10k RPM Disk |
• optional: SQL device logs on TempDB on separate RAID possibly OS on separate RAID; "live" changelog on separate RAID 1. |
In case of SAN or DAS HBA speed (and switching speed for SAN only) is usually bottleneck to watch for. |
|
|
