title: SQL Server Buffer cache content
body: <p>I'm having an issue on my instance page life expectancy would drop to a few seconds.<br>
  I know this is due bad code, and I'm trying to find out which object pages are in the buffer cache. That would lead me to what causes the problem. Kind of v$bh equivalent in Oracle.</p>
  
  <p><strong>Edit</strong></p>
  
  <p>I came across <a href="http://www.sqlskills.com/BLOGS/PAUL/post/Performance-issues-from-wasted-buffer-pool-memory.aspx" rel="nofollow">this great article</a> which talk about the issue I got with pagelife expectancy. And how to find the buffer content.</p>
  
  <p>Thanks,</p>