<div>
SQL Server grabs the memory only when its needed and will keep it for itself till the maximum memory settings you have configured. As far as sql server 2014 std edition is considered, it could allocate upto 64GB RAM.
</div>


SQL Server grabs the memory only when its needed and will keep it for itself till the maximum memory settings you have configured. As far as sql server 2014 std edition is considered, it could allocate upto 64GB RAM.

<div>
dgerler, a feedback will be appreciated.
</div>


<div>
Thank you. It was really an overall usage of RAM including the OS. It ended up the problem was the application was running very slow because of Antivirus scanning everything. It seemed like the RAM usage should have ramped up faster and did eventually. We fixed the antivirus issue and the application completed as expected.
</div>


Thank you. It was really an overall usage of RAM including the OS. It ended up the problem was the application was running very slow because of Antivirus scanning everything. It seemed like the RAM usage should have ramped up faster and did eventually. We fixed the antivirus issue and the application completed as expected.

<div>
<div class="content wysiwyg-content">
We are in the process of building a new MS Dynamics GP server. We have installed windows server 2016 std and SQL server 2014 std. and Dynamics GP 2016. We have set the maximum memory in the Server properties to 60GB out of t he 64GB RAM &quot;installed&quot; in &nbsp;this VM.<br />
<br />
We are currently upgrading the databases from GP 2015 to GO 2016 SQL Server and the OS and SQL Server are only using 5 GB RAM and the GP Expert thinks it should be using much more RAM at this point. <br />
<br />
Can anyone give me some ideas on what to check for why SQL is not using much more RAM?
</div>
</div>


We are in the process of building a new MS Dynamics GP server. We have installed windows server 2016 std and SQL server 2014 std. and Dynamics GP 2016. We have set the maximum memory in the Server properties to 60GB out of t he 64GB RAM "installed" in  this VM.

We are currently upgrading the databases from GP 2015 to GO 2016 SQL Server and the OS and SQL Server are only using 5 GB RAM and the GP Expert thinks it should be using much more RAM at this point. 

Can anyone give me some ideas on what to check for why SQL is not using much more RAM?

SQL Server 2014 STD not using available memory

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Windows 10 is a personal computer operating system featuring the "universal application architecture" (UAP); apps can be designed to run across multiple devices with nearly identical code, including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Windows 10 also includes a virtual desktop system, a window and desktop management feature called Task View, the Microsoft Edge web browser, support for fingerprint and face recognition login, voice-based search (Cortana), new security features for enterprise environments, and DirectX 12 and WDDM 2.0 to improve the operating system's graphics capabilities for games.

Windows 10

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

Windows Server 2016 is the successor to Windows Server 2012 R2. Built upon the same core code as Windows 10, Windows Server 2016 brings enhancements in security, servicing, and connectivity. A particular focus on this release was hybrid-cloud scenarios, and has close ties to Azure and other Microsoft cloud initiatives. This does not detract from the many improvements that are available for on-premises-only deployments

Windows Server 2016 comes in Datacenter, Standard, and Essentials editions, and for servicing, has adopted windows 10's cumulative model. The new nano-server install is designed to be remotely managed and is designed to be kept current through continuous feature updates. The full GUI install operates similarly to windows 10's "Long Term Servicing Branch" (LTSB) model with cumulative security updates.

Windows Server 2016 has also shifted from a per-processor-and-CAL licensing model to a per-core-and CAL licensing model. This brings Windows Server's licensing more in line with Microsoft's other products and makes hybrid-cloud license planning easier as well.