Solved

sql server 2012 MEMORYCLERK_SQLCLR takes most memory

Posted on 2014-09-22
4
1,029 Views
Last Modified: 2014-09-23
we have a sql 2012 server, and recently we experience periodically page life downgrades to 0 problem. The frequency is every a few hours.
When I checked memory usage, MEMORYCLERK_SQLCLR takes most of the memory, more than MEMORYCLERK_SQLBUFFERPOOL, the details is in attached picture.

And I used profiler to check what is running in SQL Server while page life suddenly downgrades to 0, and I found only log shipping backup processes are running at the time.. Is it log shipping caused problem? Though the log backup running at the time is for very small database (under 200MB)... The proflier and performance data screenshot is also attached.

Appreciate for your kindly help, any idea is appreciated a lot!
memory-usage.jpg
Profiler-perf.jpg
0
Comment
Question by:xuewei shi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40338889
Hi xuewei,

This is todays result?
For now it's only having the highest amount of memory reserved, not used.
Do you remember that long running SP that you showed me in another question? I think it might uses CLR as I can't figure any other option here. Unfortunaly the only way to clean MEMORYCLERK_SQLCLR  is restarting the service.
0
 

Author Comment

by:xuewei shi
ID: 40339212
Good day Vitor! Yes this is today's result. Now still about 12GB is reserved for CLR, so does it mean this 12GB memory cannot be used by SQL buffer pool, is my understanding right? Thank you!
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40339536
I'm afraid that's correct.
For now are you having performance issues? If not, wait for the next reboot and check again the memoryclerk.
0
 

Author Closing Comment

by:xuewei shi
ID: 40340638
Thank you so much Vitor for your help!!
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
export sql server dbs 2 26
SQL Server Error: 4060 8 33
File attachment in the SQL Database from application 10 47
sql server string_split 4 28
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question