Browse by Tags

• allocated
• buffer
• cache
• configuration
• distribution
• indexes
• management
• memory_clerk
• sql server
• table
• tsql

SQL Server 2005 TSQL to obtain buffers by object (table, index) in the buffer cache?
01 February 08 05:30 AM | SQL Master | 2 Comments   

As a programmer interacting with SQL Server's cache is not often needed, but when you do need to determine what is going on with the cache, or you simply need to flush the execution plans or data pages to tune a query, you now have the means to do so. Read More...

Filed under: tsql, sql server, indexes, cache, dmv, memory, buffer, table, configuration

TSQL to get a quick information on detailed distribution of memory allocated
10 January 08 02:04 PM | SQL Master | 2 Comments   

By design the components that are aware of the SQL Server memory management mechanisms use the buffer pool for small memory allocations. If the allocation is bigger than 8 KB, these components use memory outside of the buffer pool through the multi-page Read More...

Filed under: tsql, sql server, dmv, memory, allocated, distribution, management, memory_clerk