How to choose which edition of SQL Server and which edition of Sharepoint that goes with MS Dynamics CRM

Posted on 2011-10-25
Last Modified: 2012-05-12
We will be installing the MS Dynamics CRM along with SQL Server and SharePoint.
I am a not sure what Criteria are appropriate to choose the edition of SQL and Sharepoint?

We have 150 employees and about 1000 customers that will be accessing the CRM.
Not all the customers will be accessing the CRM system at the same time.  The system requires to track ALL emails between our employees and  customers for compliance.

Eventually, we would like to use the CRM to implement the entire company workflow into the CRM.

Any suggestion if SQL Server Standard and SharePoint foundation will be sufficient?

Question by:tommym121
    LVL 50

    Accepted Solution

    what volume of emails are you expecting?
    what will be the total database size?
     (initially, after 1 year, after 5 years...)
      archiving strategy?

    what sort of queries will be performed?
    24/7 or business hours?

    what batch processing will be performed?

    how many transactions per day/hour  ... (avg, peak)

    what compliance model are you thinking of? (SOX,BASEL,...)?

    the above are a starter set of the questions you need to be thinking of...
    LVL 38

    Assisted Solution

    If you are using the full version of SharePoint, use a full version of SQL Server.

    If you want to have the ability to compress SQL backups, use PowerPivot for SharePoint, or have a large SQL cluster, use Enterprise.  Otherwise, go with Standard.

    Author Closing Comment


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now