Allocated memory alert

[hatred]

I have setup a new server and after some days, I was getting the below notification:

A large amount of memory is committed to applications and processes. Consistently high memory usage can cause performance problems.

After when I checked the task manager at the server i found the below things:
store.exe 566,328 K
sqlservr.exe 181,448 K
sqlservr.exe 46,492 K
sqlservr.exe 12,192 K
w3wp.exe 136,424K
w3wp.exe 74,500 K
w3wp.exe 15,576 K

Also, to let you all know, the server crashed a few times in the past few days. It seems to be a faulty hardware and a Dell technician is coming to fix it today. Any help in the meanwhile would be good.

[rossen]

You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad. For more information, go to this link - http://blogs.technet.com/b/sbs/archi...07/433707.aspx

[Killen]

Could you please tell us how much memory you have on your server?

[hatred]

I have got 4gb memory on my server. I have noticed a few more times and store.exe if the largest process with about 400,000K and then 3 sqlservr.exe with 100,000 each. The task manager is showing that I have about 1gb free at any time. I have got a small network with four computers only.

[Dr.pter]

You can try to adjust memory usage by using configuration options in SQL Server. When you start Microsoft SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. You can find more information on how to solve this issue from here - http://support.microsoft.com/?id=321363

[Metaldigger]

I have heard that store.exe is designed to use whatever memory it needs and then release it as required. You can try to check out SQL instances on adjusting the allocated memory for SQL:

http://msmvps.com/blogs/bradley/arch.../04/34984.aspx