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

    • 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 ...

    • Methods of back up of Enterprise Server SQL Database

      Version: Not any specific version. Query: Kindly advise methods of backup of Enterprise Server SQL database. Answer: We can only take SQL backup from SQL Server only for enterprise databases. We don't have any utility to take an enterprise backup. ...

    • Is iVend 6.6 compatibility with SQL Server 2019?

      Version: 6.6 Query: Is iVend 6.6 compatibility with SQL Server 2019? Answer: Yes, the below latest version of SQL is compatible with iVend 6.6 Miicrosoft® SQL Server 2019 - 64 Bit (x64) - Express, Standard, Enterprise Edition Note: Also find attached ...