Beyond Web Logs

Sometimes SQL Server Service sqlservr.exe is cause system slowness due to high memory usage, same issue was with me, while checking this issue, i come to know that we need to set maximum memory usage in SQL server, after setting this system is working fine, but you may need to set memory size according to your database needs.

SQL Server does not de-commit any buffers, thus leaving the committed buffers in memory for fast access and better performance. The buffer stores execution plans, creates temporary indexes and allocates cursors. In fact books on-line recommends setting the minimum and maximum memory used on each instance of SQL Server running on the same machine as SQL Server does not make any attempts to balance memory usage across instances.

Steps to set maximum memory size in SQL:

1. Login to your server with administrator rights
1. Right click On server name
2. Click Properties
3. Click Memory
4. Here you will find “maximum server memory in MB” type your required memory size there
5. Click OK.

Look now your memory is fine, and system will perform better.

That's all ! Good Luck

SQL Server