1
kudos
spam Kudos Remove

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave
published 692 days, 21 hours, 54 minutes ago posted by pinaldavepinaldave 701 days, 7 hours, 27 minutes ago
Tuesday, June 29, 2010 1:05:59 PM GMT Monday, June 21, 2010 3:32:59 AM GMT
SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave

This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query. Have you ever wondered what types of data are there in your cache? During SQL Server Trainings, I am usually asked if thereis any way one can know how much data in a table is stored in the memory cache? The more detailed question I usually get is if there are multiple indexes on table (and used in a query), were the data of the single table stored mu...

category: Query | clicked: 2 | | source: blog.sqlauthority.com | show counter code
tags: pinaldave, SQL, SQLAuthority, SQLServer

No comments yet, be the first one to post comment.

To post your comment please login or signup