Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Abhineet
Starting Member
1 Post |
 Posted - 2012-10-04 : 02:59:06
|
| We have a Windows Form Application and the back-end of the application is SQL Server Express 2005/2008. Our application can be installed on Windows XP SP3/ Windows Vista/ Windows 7.We have observed huge memory leakage in SQL Server Express.Normally, there are two process running even if the application is not used by the user:1. A polling process to check the availability of files. (If files are not available then, only one query is fired to check some configuration setting)2. A Scheduling process. (This process fires a query every minute to check for any scheduled task)We have observed that the memory usage of the SQL Server (sqlsrvr.exe) keeps on increasing. In around an hour, the memory usage reaches upto 1GB and it never comes down.We have also noticed that, if the interval of the polling process is increased, then the memory usage increases gradually but, it does increase.The higher memory usage by SQL server downgrades the machine performance and the performance of all other applications running on the machine.Please provide suggestions to control the memory usage of SQL server in this case.PFB the details:1. Software causing issue :SQL Server 2005/2008 Express editions2. Operating Systems on which issue can be simulated : Windows XP SP3/ Windows Vista/ Windows 7Regards,Abhineet |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-04 : 07:19:03
|
| This probably is a case of SQL Server grabbing as much memory as it is allowed to - which is by design. Right-click on the server in the object explorer in SSMS and select properties. In the memory tab, it will show you the maximum memory SQL OS is allowed to take. You would want to reduce that making sure that you leave enough memory for Windows and for other applications.Google for "configuring maximum memory in sql server" and you will see MSDN guidelines on how to and what to set the maximum memory to. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-05 : 01:42:16
|
| Once you've configured the server as required, and you still think there is a memory leak - use an app such as poolmon.exe to identify any memory leaksJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
SQL Server Express Edition Memory Leakage