So, on Windows 10, the only SQL you should be running would be SQL Express and AC's instance on it. SQL Express, itself, will require RAM to run, but it won't be a huge amount. Many times as you watch the amount of RAM your server or Windows 10 is taking, people will refer to this as a memory leak. There are such things, but in this situation, that is not what is happening. SQL Express is limited in some things, hence the reason Microsoft gives away for free. One of the main limitations is the amount of RAM SQL Express is allowed to use or take from the OS, not to run SQL but to work within the instance of AC. SQL Server's instance (a SQL Server engine can run many instances -- one of which is AC) will take as much memory as the OS has limited by the amount it is allowed to take. With SQL Standard 2012, etc. this is pretty much unlimited. You must go into SQL and set how much RAM each instance is allowed. But, you can see that with larger companies and more databases, especially HUGE databases, having a lot more memory is beneficial. For the most part, with AC and 12 users, etc., you don't need a lot of RAM.
Last edited by Bert; 05/19/2018 11:40 PM. Reason: Update on SQL version
