Recently we have installed SQL Server 2012 Web edition (64 Bit) in Windows server 2012 Std edition (64 Bit). The Windows server having 8GB of memory.That server is mapping with an alert tool (which is crossing the threshold memory of 80%).
Actually the problem is most of the time, the windows task manager is showing as SQL Server taking 85% to 95% of memory(Even though there is no much operation). So that the alert tool keep on sends the alert.
- Now, how can I find that SQL server is really taking the much memory?
- Should I configure the minimum server memory and maximum server memory option in SQL Server?
Thanks in advance,