How to release Memory when w3wp process taking lots of memory

I have a server configuration intel xeon 2.4 quad core , 32 GB ram,

and on the server CRM application is running on that server,
my problem is that ,

W3wp process taking lots of memory utilized . it starts 3 GB to 31 GB,

Kindly help me out .
Process-crm-prod.xls
vicky1982Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sharepointguru14Commented:
1 use a garden for worker processes. Here is a link to configure that http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/659f2e2c-a58b-4770-833b-df96cabe569e.mspx?mfr=true

Second sounds like your application has a memory leak. This is something that you will have to debug within the application code. As a temporary fix to stop it from crashing the system you can recycle your worker processes every so often or when it consumes a certain amount of memory. In the mean time Use DebugDiag to get more detailed information on what is causing the problem to hand off to your development team or vendor of the application
http://support.microsoft.com/kb/919791/
0
sharepointguru14Commented:
Just saw your attachment. Looks like you are already running debugdiag. Have you caught a crash yet? If so post that log
0
vicky1982Author Commented:
no, nothing found,

i did webgarden process 1 to 16 but can't find any output of memory leakeage
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

sharepointguru14Commented:
there is no reason for a worker process to be consuming 30GB of RAM. Your app has a memory leak for sure. Catch the next time it crashes and post the debugdiag log for us to review
0
vicky1982Author Commented:
I have test and observe that w3wp.exe process are 20 instances running and each instances taking memory 500 mb and its continously increasing not realease the memory.

My application is running CRM and database is SQL ,

SQl taking only 500 MB memory,

any suugestion
0
sharepointguru14Commented:
limit the number of instances of the worker process just at 500mb that is 10GB being consumed. And then send us the logs from debugdiag for review. I need to see whats happening in order to tell you how to fix it. I can't just imagine what the problem is and give you a fix
0
vicky1982Author Commented:
I have tried to first IIS admin server Stop then its realease onle 6 GB Memory out of 32 GB, after that I down the Sql Database after down the database memory came to 2 GB Used and 30 Gb free,

what this its mean is there any issue with database or problem with my CRM Application.
0
sharepointguru14Commented:
before turning off SQL how much memory was being consumed? Can you take a screenshot of the processes running when you have 30+GB of memory being used? If its SQL consuming all the RAM then you need to do some performance tuning on SQL. Here is a link that gives basic background from microsoft on that.http://support.microsoft.com/kb/321363
0
vicky1982Author Commented:
before Turning off the Sql it take is taking 26 gb out of 32 GB after turning off the sql server service it come to 2GB.

performance-rep.JPG
0
vicky1982Author Commented:
there is one more screenshot of Process
0
vicky1982Author Commented:
process screenshot
process.JPG
0
vicky1982Author Commented:
I have resolved the High Memory Utilization Issue ,

Actually in Server there is Sql Server database is running, in database there is Two Instances Created, both Instances have max memory set Unlimited, after setting the Max memory to 5 GB each instances , its cames to its normal postion, now its taking only 7 to 8 GB memory .
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vicky1982Author Commented:
No There is no objection
0
vicky1982Author Commented:
for resolving this I have done Windows Latest Security Patch , OS kernel, Crm Application UR 5 (Update rollup)

Lastly i Did max memory set in Sql.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.