Community

What’s swimming in your bufferpool?

(Tony Voellm and Gaurav Bindlish) When doing a performance investigation a useful thing to do is look at what data is present in the buffer pool. This can be used to analyze impact of running a query on the state of data pages in buffer pool. By collecting the pre and post picture of buffer pool, y

Read More - Register for Free Membership