Jason-299789 (4/17/2015)
HiWe have Virtual SharePoint DB server with 16GB ram, 1 socket 4 virtual CPU's running at 2ghz.
Yesterday around 6:30am the CPU on this box started going haywire (90%), when looking at the Performance stats for SQL I see a very high PLE, in the region of 20,000 and very low Cache hit 22%.
Yes on the UAT box with the same build, it was running at a PLE of 100-200 average and Cache hit ratio of 90%+, which is what I expect to see.
I've suggested doubling the memory to 32GB, but I think this is papering over the cracks and I'd like to know if there is anything else that can be done.
Regards
Jason.
Quick question, what are the SQL Memory configurations (Min and Max Memory)? Looks to me that the OS is somewhat short of memory, 16Gb suggests around 8Gb Max Memory for the SQL Server.
😎