Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SQL Server Architecture
Microsoft Dynamics CRM (Archived)

SQL Server Architecture

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi, we are a Company with 1500 employees. We want to implement Dynamics CRM 2016. Now, I have a question to the SQL Server Architecture. We have an separate RS Server for the Reporting Services and an separate Server for the DB-Instance (separation Front- BackEnd). On the DB-Server runs the Application-Database and in another Instance, on the same Server, the ReportServer-Databases. Do you see any Problems about the Performance? (Workload ReportServerDB and OLTP Database) Thanks a lot. Martin

*This post is locked for comments

  • Suggested answer
    M.T. Eikelenboom Profile Picture
    M.T. Eikelenboom 5,241 on at
    RE: SQL Server Architecture

    I agree with Sergey in that the reporting server is probably not going to be used very often with a new implementation, unless you know up front that it's going to be very important.

    PowerBI is far more user friendly for dashboarding and if you get very serious in using CRM, there's most likely going to be a DWH.

  • Suggested answer
    SergeyT Profile Picture
    SergeyT 310 on at
    RE: SQL Server Architecture

    I would put Reporting DB on the same SQL instance and installed SSRS on a separate windows machine and forgot about it. The reasoning behind this:

    • Premature optimization is the root of all evil
    • You can scale that windows machine separately
    • You can always backup\restore Reporting DB to separate SQL instance if in need
    • Since you just starting adopting Dynamics probably there are no millions records
    • Reports is not something users runs constantly in day to day routine (IMHO). There are views, charts, dashboards for day-to-day use in Dynamics. And they aren't run via SSRS.
    • You need great analytic? - take Power BI or any other BI tool and scale it.
    • Probably there will be separated DWH for yours BI solution
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Server Architecture

    Hi, thank you. At the moment it is not our main application, but in the next few years it should be. Then we expect that about 1000 persons use the CRM, but it is improbable that all create reports at the same time..... I think in the beginning it is too much to install a separate SQL Server just for the Report Server Databases. or not? I don't know what is recommended for us and what is recommended for small or bigger environments.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Server Architecture

    Hi, thank you for your answer. You're right, the server specifikation and other factors are also important. The server has 64GB RAM and 4 CPUs and running on Windows Server 2016 and SQL Server 2016 EE CU2.... I can't find a recommended server architecture for Dynamics CRM.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: SQL Server Architecture

    As per the previous reply, more factors are involved to be certain. Probably the most significant are:

    • How heavily the 1600 user use CRM. If for most of them it is their main application, then this is very different from most users only occasionally accessing CRM
    • The reporting load. If a lot of users frequently run a lot of complex reports, this will add noticeable load onto the system
  • Suggested answer
    M.T. Eikelenboom Profile Picture
    M.T. Eikelenboom 5,241 on at
    RE: SQL Server Architecture

    Hi,

    I think it depends on a lot more than just your configuration in servers. Other factors are also important, like the expected load, server processing power, memory, disk IOPS etc.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans