October 21, 2013 at 11:13 am
Greetings,
While querying sys.dm_os_buffer_descriptors I noticed that in some cases I have objects that have not be referenced for weeks. I have very high BCHR% and Page Lifes > 145K. I want to believe that unreferenced objects would eventual get pushed out of the LRU list. Is their some reason why they might remain? Not a big deal but inquiring minds want to know.
October 21, 2013 at 11:38 am
If there's no demand for free pages, no pressure to remove objects from cache to make space for new pages, then older objects could stay in cache for long periods. High page life and high hit ratio suggest minimal memory pressure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2013 at 4:27 pm
In short, you're in a great situation. Leave it alone.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply