SQL Server isn’t releasing memory

Question

0.00/5 (No votes)

See more:

Hi Everyone,

I have one application written in MFC which fetches a some record set's from database with regular intervals, My problem is that onces the application is get started it couses the increase in sql memory and it does not release it.

I have check my mfc application for memory leaks but it dont have any memory leaks.
I google it, and i found some solution for this problem but that is not helpfull for me. what i want that When even i will close my application sql server should release the memory.

Please help me!

Posted 24-Apr-11 18:52pm

LaxmikantYadav

Updated 26-Apr-11 23:51pm

v2

Add a Solution

Comments

Albert Holguin 25-Apr-11 21:24pm

post some code and/or clarification, your question is too vague

LaxmikantYadav 27-Apr-11 5:44am

Can you help me in this ?

LaxmikantYadav 26-Apr-11 7:53am

The MaxServerMemory of sql server is set to 1GB, but sql server usage more than 1GB memory, so can you tell me how to prevent it.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pikitfense · Answer 1 · 2011-04-27T10:18:00

Actually SQL server does not release memory when once it grabs ahold of it. I have written a little script that I use to release memory. However you should NOT run this on a busy server.

the 512 number can be changed to a lower number but be careful as you might crash your server with too low of a number.

USE master

EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'max server memory (MB)'

EXEC sp_configure 'max server memory (MB)', 512
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'max server memory (MB)'

WAITFOR DELAY '00:00:15';

EXEC sp_configure 'max server memory (MB)', 2147483647
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'max server memory (MB)'

EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
go

-Thomas Ross, pikitfense at h o t m a i l dot com

*dan!sh* · Answer 2 · 2011-04-24T19:02:00

Solution 1

I don't know MFC. But, can you check if you are properly closing/disposing the connection objects? Also, have you thought of considering ConnectionPooling?

Posted 24-Apr-11 19:02pm

dan!sh

Comments

LaxmikantYadav 25-Apr-11 1:05am

Yes, All Connections are closed in the application.

dan!sh 25-Apr-11 1:13am

Sorry I don't understand that. Can you describe what you mean?

LaxmikantYadav 25-Apr-11 1:45am

All the connection objects are properly closed/disposed in application..

LaxmikantYadav 27-Apr-11 5:44am

Can you help me in this ?

RDBurmon · Answer 3 · 2011-04-27T01:37:00

Its also depend upon what driver you have used to connect the SQL server.
Please use SQL server OLE db driver and connector .
Since it is very flexible to allocate and releas memory objects.

It also depends upon what method you have used to pull out data from SQL server.

I suspect you should use Stored procedure and call that SP from within your code.

Please avoid looping thoruhg the record set .
It would be very nice if you set up one shot activity.

SQL Server isn’t releasing memory

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0