I want to talk about one of the most discussed SQL issues. Memory memory management.
I am working on a SQL server 2008 R2 with all the combined DBs of 60GB. User activity is not very high. This is sharepoint DB. Most of the time CPU utilization is not very high but memory is consumed around 98%.
Current memory is 12GB. How can I calculate the memory required on this server.
View Complete Post