Red Gate forums :: View topic - large object in buffer cache
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

large object in buffer cache

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
stevenhoban



Joined: 18 Apr 2013
Posts: 14

PostPosted: Thu Apr 18, 2013 4:49 pm    Post subject: large object in buffer cache Reply with quote

"LARGE OBJECT IN BUFFER CACHE"
Can anybody advise me on the action to take when i see this alert in sql monitor.
We have it set at the default values and I am wondering on the best techniques to remedy the situation. Some of our overnight ETL jobs are taking 3 hours when they used to run in 20 mins and i am wondering if this 'large object in buffer cache' is having an impact.
Thanks
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Sat Apr 20, 2013 12:02 am    Post subject: Reply with quote

This alert is raised when the amount of memory used in the buffer cache by the largest object (based on the number of pages) goes above a specified threshold. It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used.
It is very common for one or two objects to be responsible for using a large amount of the buffer cache. To increase the efficiency of the buffer cache area, these objects may benefit from a schema revision (datatype changes or sparse columns), and are great candidates for compression.

For more information, see http://blogs.msdn.com/b/chadboyd/archive/2007/02/02/sys-dm-os-buffer-descriptors-aggregations.aspx and http://www.simple-talk.com/community/blogs/jonathanallen/archive/2012/06/12/110696.aspx.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
stevenhoban



Joined: 18 Apr 2013
Posts: 14

PostPosted: Sat Apr 20, 2013 6:09 pm    Post subject: Reply with quote

Thanks for the reply. Unfortunately I have seen this post as it is just from the 'SQL Monitor' description field.
I have checked out the scripts in the link. What i am really asking here is what to do once i have identified this large object in the buffer cache. Do i somehow flush it from the cache, then maybe use one of the methods listed so it doesnt take up as much space the next time it is loaded in memory ?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group