Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

SQL server. SQL Instance vs Dedicated SQL server?

Like (0) ShareShare
ReportReport
Posted on 16 Oct 2015 14:47:58 by

This question is with reference to Microsoft Dynamics CRM 2015 & SQL Server 2012.

I am trying to understand what the differences/considerations are between hosting a CRM database on a dedicated SQL server compared to an SQL instance on a SQL server where there are other instances hosting other databases.

In particular this would be a question around performance - i'd imagine that a dedicated SQL Server would be the way to go, though I don't understand exactly why this would be?

Any input would be appreciated.

Many thanks,

David

*This post is locked for comments

  • Suggested answer
    Manoj Batchu Profile Picture
    Manoj Batchu 1,691 on 17 Oct 2015 at 07:40:53
    RE: SQL server. SQL Instance vs Dedicated SQL server?

    Hello David,

    As Bas suggested, you can go either for a SQL Instance or a Dedicated Server based on the Budget and Project requirements.

    Even though you use a SQL Instance, you can assign required resources to the SQL instance like Dedicated Memory which is optimal for the performance.

    msdn.microsoft.com/.../ms178067(v=sql.110).aspx

    blogs.msdn.com/.../importance-of-setting-max-server-memory-in-sql-server-and-how-to-set-it.aspx

  • Suggested answer
    Bas van de Sande Profile Picture
    Bas van de Sande 4,383 on 16 Oct 2015 at 21:56:33
    RE: SQL server. SQL Instance vs Dedicated SQL server?

    Hi David,

    whether it is smarter to use a dedicated server or a shared server (instance) depends on the size of your operation (number of concurrent users), database applications hosted on the server, available hardware, availability etc.

    There is not really a rule of thumb.

    What I see in the field, is that large organizations use a couple of big SQL Server clusters with a dedicated san storage. In those organizations you get an instance.

    I think you should look at it at a project basis. One of the questions you have to ask your self is what the budget of the customer is. Small budgets often means that you have to cut in licenses (thus using existing sql servers). In case budget is not an issue, then I would recommend to go for a dedicated server (but that's just my opinion)

    I hope my opinion gives you some insights

    Bas

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,257 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,028 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans