SQL Server is designed to use all the system memory available. This is fine if you are using a dedicated server but if you will be running other applications you can limit the amount of memory SQL Server can have access to. Recommend running SQL server on a dedicated server If you plan to use active-e services or active-e Mobile Applications, you can use SQL Express or SQL Standard (licensed by CPU core). You should not purchase SQL Standard (licensed by server + users). You are required to purchase licensing for all cores of the machine, but if you use a VM, you can limit the number of cores that need to be licensed. CHOOSING your SQL SERVER EDITION |
