Limit SQL SERVER memory consumption

Limit SQL SERVER memory consumption

Version:

Not the version-specific

Query:

Below query has been raised by one of the iVend user.

I am experiencing in my HO server a lot of memory consumption when I checked it was the SQL SERVER,  so I want to ask you if I can limit it,  defining in SQL Server Properties, Server memory properties a max limit,  what would you advise me?  I have 16GB of RAM in the HO Server.

Answer:

Query raised was towards managing Memory of the RDBMS system ( SQL server in this case). Managing Database and it's properties should be handled by the IT team of the iVend Customer.

    • Related Articles

    • compatibility version SAP & SQL Version

      Product Query Customer currently using the SQL version 2016 in HO and stores in 2008 express . SQL 2019 and higher version will support ivend 6.6? SAP Version 10 and Pl 2405 and higher PL version will compatible with ivend integration ? Answer As per ...

    • Microsoft SQL Server Database Maintenance activity

      Database health check & Optimization steps Steps and walkthrough to do a health check and optimization of iVend database. The entire process broadly consists of 8 steps: Step 1: Take Backup of DB. Open SQL Server Management Studio Express and connect ...

    • iVend Api Browse error Memory gates checking failed because the free memory

      Environment iVend Retail 6.6 integrated with SAP B1 Problem Statement At the time of browse Api on Enterprise its showing below Error Memory gates checking failed because the free memory (910630912 bytes) is less than 5% of total memory. As a result, ...

    • Linked server creation from SAPB1 HANA Server to SQL Server

      Environment : iVend 6.6 With SAPB1 HANA Server Problem Statement : There is need to access SAPB1 HANA tables on iVend Enterprise database Resolution : You can check out the below video link to create Linked server from HANA to SQL Server ...

    • SQL server 2016 : Database Mirroring for High Availability

      Query: Customer is planning to set up Database Mirroring for High Availability in his test environment. In SQL 2016 version is this supported? Response: Database High availability is the concept related to RDBMS and not with iVend application. Below ...