SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server Express Edition Memory Leakage
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Abhineet
Starting Member

India
1 Posts

Posted - 10/04/2012 :  02:59:06  Show Profile  Reply with Quote
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 editions

2. Operating Systems on which issue can be simulated : Windows XP SP3/ Windows Vista/ Windows 7

Regards,

Abhineet

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 10/04/2012 :  07:19:03  Show Profile  Reply with Quote
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.

Edited by - sunitabeck on 10/04/2012 07:19:38
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2046 Posts

Posted - 10/05/2012 :  01:42:16  Show Profile  Visit jackv's Homepage  Reply with Quote
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 leaks

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000