These are all questions your reseller should be answering for you.

hahahaha

Hi Paula,

Sage 100 Premium includes a bundled version of MS SQL Server 2010.  Response times will be faster if MS SQL and the Sage Application Server are installed on the same system (this is true for all applications as it  eliminates network bandwidth issues)

John Nichols

Sage

Thank you J.   I asked my reseller and received a different answer.  He said we would have to purchase MS Server server and licenses for everyone that accesses MAS.  (20)  He said that they should be on separate servers, as SQL will take up all the performance.   I keep hoping I can get one spec sheet or white paper on the exact requirements and pricing and suggested configuration.  (It's not that easy)

Hi Paula,

Clarification: We bundle MS SQL Server 2008 r2 with Sage 100 Premium.  I 'll post a link with the recommended system requirements.  

John Nichols

Sage

Hi Paula,

Clarification: We bundle MS SQL Server 2008 r2 with Sage 100 Premium.  I 'll post a link with the recommended system requirements.  

John Nichols

Sage

Thank you very much!

Paula when you purchase Sage 100 Premium you have the option of purchasing the SQL licenses at the same time thru Sage at a discounted rate compared to full sql licensing, this is an option and not something that is bundled at no cost.  Also it is a SQL run-time, meaning it is only licensed to be used by Sage products.    So as an organization if you have other software packages or database needs you may be better purchasing SQL Server outside of the runtime.  If not then the Sage runtime version works great.

ok...i think i have FINALLY come to a decision.  I got hold of a tech/mechanic at Sage.  His recommendation is to stick with what we have (Sage 100 Advanced).  The only people who really have a use for the SQL version would definitely need SQL Server.  They probably would have other SQL ERP systems that require SQL and suggested we would also need a staff  DBA.    Thanks everyone, for your information.  I couldn't have done this with this forum!

John (or whoever is reading this), we have a Sage 100 customer looking at this same question.  The SPM for Sage 100 Premium includes specs for Sage products, but does not specify what the db server requirements are for Sage 100 Premium.  Is there any documentation for this?  Is there a recommended configuration for having SQL on a separate server vs the same server as the application?

Look to Microsoft documentation for SQL server requirements.  AFAIK the version you can purchase from Sage is limited to use with Sage 100 only.  If you buy it separately you could potentially use the SQL instance for any unrelated database server needs your organization may have.

SQL can be on the same server as the Sage 100 service and a proper DBA can tune the SQL settings to not consume all the machine resources.  If it's on a separate server be sure to have a super high speed network connection between the machines.

Understood on your points.  The main concern I have is that the SPM for Sage 100 Advanced and Sage 100 Premium is basically identical on server specs, which leads me to believe it's not factoring in SQL Server on the server performance.  I'm not concerned about getting SQL installed (we work with it all the time w/ Sage 300), but just making sure that our server(s) have enough resources to handle the additional load that SQL Server generally entails.

In Sage 300, for example, Sage includes a section specifically on the database server and what resources need to be available on that server for the product to function well.  Sage 100 Premium is no different in the sense that it's an application with a SQL Server back end.  SQL can be a resource hog and so it makes sense to spell out average requirements per user or SQL instance.  Does anything along those lines exist?

Not that I am aware of.

Received the following from John Nickols at Sage, found it helpful.  Thought I'd post here for others.

=====

You can configure the Sage 100 Premium Application Server on its own dedicated server and MS SQL Server on a separate server or install both on the same server. The server should be dedicated to processing Sage 100 and not a domain controller, mail server etc.....

The hardware requirements listed in the SPM are minimums. The software will run under these minimums but performance may be an issue. There are too many variables to determine performance in this time frame.

The minimum for 64-bit system server: CPU Intel or AMD 64-bit capable, Quad Code 2.4 Ghz minimum (faster is always better)

Network - minimum bandwidth 100 Mbps network connection (more bandwidth is always better)

Memory - minimum 2GB + 4-6MB per concurrent users (More is always better)  

What we use in house for testing: (this is not a recommendation only a reference to internal testing use)

Sage 100 Premium and MS SQL Server x64 2016 installed on a dedicated server.   The settings below may or may not be sufficient for 40 concurrent users (More is always better)

Server

O/S MS Server 2016 x64

8 Processer Core CPU 2.4Ghz each

32 GB RAM

1 GB network

MS SQL Server 2016 x64

Workstation

O/S MS Windows 7 Windows 10 x64

2 Core CPU 2.4 GHz each

8 GB RAM

1 GB network