Posted on 2006-05-18
I'm running SBS 2003 Premium. Running Exchange, SQL Server, CRM (SBS edition), IIS etc. Only thing we're not using is ISA.
CRM is a major DOG on this hardware: Duel-core P4 2.8 Ghz. 1 GB RAM. RAID1 (SATA) via Intel Matrix on Motherboard. OS on 12 GB partition. Data on 100 GB partition.
I need to get decent performance. The bottleneck definitely seems to be disk ... based on the performance counters. The CPU and memory counters don't flinch when the box drags, but the disk counters are pegged!
I understand that there are things that should be done to improve the disk performance. For example, add a second physical drive array (RAID1 or RAID5) for data. Separate the SQL server database and trans. logs onto different physical volumes. Separate the Exchange store and logs etc. Maybe some IIS-specific tweaks for CRM?
If you were going to design a maxed-out SBS box to run this stuff (CRM included) well, what would you build/buy? And how would you configure for best performance of CRM. For example, splitting SQL DB and Trans. logs... etc.
I just need SBS to run with CRM well enough to use for the next year or two while we grow. If this can be done by upgrading my existing box, all the better. If I need to start from scratch on the hardware, I can do that if the performance will be snappy.
Your expertise is appreciated!!!