SQL Server 2k5 memory consumption?

Question

I have a vm development on which the sql server is running, as well as some other applications for my stack, and I found that other applications work horribly. After some digging, SQL Server clogged the memory. After a quick search on the Internet, I found that by default it will consume as much memory as it can to cache data and return it to the system, as other applications do, but this process is often not fast enough, apparently, my situation - a common problem.

However, there is a way to limit the memory that SQL Server is allowed to have . My question is: how do I set this limit. Obviously, I will need to guess and check something, but is there an absolute minimum height? Any recommendations are appreciated.

Edit:

I note that there are 2 gigabytes of memory on the developer's machines, so I would like to be able to run vm at 768 mb or less, if possible. This vm will be used only for local developers and testing, so the load will be minimal. After testing the code locally, it moves to another environment in which the SQL Server box is allocated. I'm really looking for minimum recommendations here

Answer 1

, , . , .

VM, 2 ?

Answer 2

SQL Server:

( )

SQL Server . ​​ , , SQL Server, , . , Web , , , SQL Server . , , . , , SQL Server, , , , SQL Server.

: . , . SQL Sever , , -.

SQL Server. . MAX memory SQL Server.

Answer 3

id vm on 768 , .

. SQL- GB

Answer 4

It really depends on what else is happening on the machine. Get the job done under typical load and look at the task manager to find out what you need for everything else. Try this number to start with.

For production machines, of course, it is best to give the machine control to the Sql server (Processors → Raise the priority of the Sql server) and allow it to have all the RAM it wants.

Since you are using virtual machines, perhaps you can create a dedicated file for Sql Server only and run everything else on another virtual machine.