We have a SQL server 2005 machine that has 3 SQL instances for our DEV/STG/UAT environments. I know
. Anyway, the actual machine has 4GB of memory, which 3GB are allocated for SQL server.
At least twice a day, one of the instance starts gobbling up the memory and the box comes down to a crawl because it starts using the hard drive as RAM.
1. Is there any way to limit the max amount of memory that each instance can use?
2. Any other tips to setup the servers properly so that happens less often?
I apologize in advance for the simplicity of the questions. I have been made the "de facto" DBA for the past few months since no one else is interested and even though I understand T-SQL quite well, I have a very long way to go on the Admin side.
Thank you for your help.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999