Learn how to a build a cloud-first strategyRegister Now


SBS Performance

Posted on 2006-05-18
Medium Priority
Last Modified: 2012-08-13
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!!!
Question by:responza
  • 2

Assisted Solution

myfootsmells earned 750 total points
ID: 16722365
1 GB RAM might not be enough since MS SQL/CRM takes up a chunk as well as Exchange information store.  Try upgrading to 2 GB and see how it fairs then.



Author Comment

ID: 16723002
...  I will probabably upgrade RAM...  but the memory performance counters were never pegged nor were the CPU counters.  It was all disk.  I'm thinking disk is the top issue.  I'm thinking another physical array will help.

Do I need to spend the bucks on SCSI, or will SATA 2 do the trick.  Anybody love or hate Adaptec vs. Promise vs. other 3rd party RAID card?

Expert Comment

ID: 16723084
SATA is pretty good now a days especially if you're on a low budget.  As far as RAID cards, I don't have a preference but my servers all do run Adaptec and Dell Perc cards.
LVL 74

Accepted Solution

Jeffrey Kane - TechSoEasy earned 750 total points
ID: 16738316
I would never use less than 2GB RAM with CRM.  Also, 12GB on your System Drive may be tight.  How much room is on that partition?  There should be at lease 20% free in order to get decent performance.  If you haven't moved EVERYTHING possible off of it yet, you should.  (http://sbsurl.com/movedata will tell you how).

I generally like to have at least 20GB for the system partition with CRM as well.  You are running the indexing service which is probably creating indexes on the C: drive and can be pretty doggedly slow.  The other thing to watch is your SBS log files.  They will become highly fragmented, especially the MSSBSSSR.log which records just about everthing the server does.  Move that log off to an archive location and it will just create a new one.  I wouldn't delete the old one just in case you want to troubleshoot something later on.


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month21 days, 4 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question