web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SQL server. SQL Instan...
Microsoft Dynamics CRM (Archived)

SQL server. SQL Instance vs Dedicated SQL server?

(0) ShareShare
ReportReport
Posted on by David_Moore

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

I have the same question (0)
  • Suggested answer
    Bas van de Sande Profile Picture
    Bas van de Sande 4,383 on at

    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

  • Suggested answer
    Manoj Batchu Profile Picture
    Manoj Batchu 1,691 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans