Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL requirements for G...
Microsoft Dynamics GP (Archived)

SQL requirements for GP 2016 --> less than 10 users

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

First off, I am a senior engineer with over 20 years of 3rd level senior engineering/architecture support. I am very knowledgeable with Microsoft products and have been using them since M$ was first released DOS and windows. I am saying this to state that I am very well versed with Microsoft and their "requirements" this is important for my question that I am posting. I work for an MSP for a multi-tenant cloud based solutions. One of our new clients uses Microsoft GP 2016 and as we are building out the  back-end infrastructure, the GP consultant the client uses (and highly relies on them for recommendations) pushed back on the design for GP with SQL on 1 server. They state Microsoft recommends a multi-server farm with separate GP and separate SQL servers. Keep in mind this is for less than 10 concurrent users so from my experience, this is way overkill. They dont need the multi-server farm but since they were recommended this by their consultant, I am trying to find any proof from Microsoft to support this. What I found instead was quite contradictory from Microsoft, they even state this can run on SQL Express with a workstation class. To me, this sounds like the consultant is wrong and this is not Microsoft's recommendations. I am basing my findings from this M$ article:

https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/system-requirements/MDGP2016_System_Requirements

Any feedback or assistance would be greatly appreciated, even better would be an article from Microsoft stating SQL and GP either need to be separated OR they can run concurrently together fine so i can go back to the client with factual articles.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL requirements for GP 2016 --> less than 10 users

    Thanks to both of you, and I feel the exact same way, its total overkill. To clarify, there are no legacy systems, this is straight up GP 2016 being moved from an on-prem to our cloud solution.  There will only be at most, 10 users at one time (but highly unlikely). I also saw the requirements from MS but no where in there does it state anything like the consultants are recommending so this is where my question arose from, what does MS really say is needed.

    I appreciate both of your responses and taking the time to reply!

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: SQL requirements for GP 2016 --> less than 10 users

    Hi,

    As mentioned by Richard, it seems to be huge setup just for 10 users.

    The recommendation for having multiple servers will be helpful only when there are other legacy systems or third party applications running on Application Server.

    If by any chance, if the Application server will have Development tools also, then the suggestion made by their external consultant is right because, the Memory usage will be much more when we tend to develop (It is kind of multi processing).

    However, if the Application Server has only GP and MR (Production Environment), then it is enough to have SQL installed on the same server.

    Thanks,

    Praveen

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SQL requirements for GP 2016 --> less than 10 users

    Here are the system requirement for GP 2016.

    https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/system-requirements/MDGP2016_System_Requirements

    In the 30 years I have been installing GP I have never used a server farm for 10 users. That would be like building a 60,000 seat stadium for a chess match. It sounds good but 99.9% of the space would lay idle.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans