Hello,
I have a re-occuring problem on 3 VM's. All 3 are running MS SQL Server, and all 3 are constantly triggering the "Virtual Machine Memory Usage" alarm. Most have 4 GB of RAM, and 2 CPU's. On one of the VM's I even set a memory reservation of the RAM. This helped some, but after running for more than 1 day it starts to alert again. This server is running our test SharePoint Database only, it runs about half the speed as our production SharePoint server does. This even happens if it is the only guest on the host.
Has anyone had any luck getting SQL Server to work without generating alarms? Or, even run close to the same speed as a physical server?
Stats:
- Memory Configured: 4800MB
- Memory Reservation: 4096
- Host Memmory: 128GB
- Host CPU 16x 2.693GHz
- VM CPU: 2
- VM C: drive 100GB (Has some file storage on it...no databases)
- VM D: Drive 100GB (Has all DB's and log files)
- Memory Ballon Average: 0
- Memory Usage average: 94.61%
- Memory Active AVG: 4601174
- Memory Granted AVG: 4655104
- SQL Server Memory in VM used: 3.7GB
- Time for production page served (Physical): 1 Second
- Time for VM Page serverd: 5 Seconds
Thanks,
Eric
