Kunal RanpuraJul 28, 20191 min readBuffer Pool Extension--Buffer Pool ExtensionAlter server configuration set buffer pool extension on (filename ='D:\extrabuffer.bpe', size = 32GB)GO
--Buffer Pool ExtensionAlter server configuration set buffer pool extension on (filename ='D:\extrabuffer.bpe', size = 32GB)GO
SQL Server Find what Objects are using space in buffer cache-- Breaks down buffers used by current database by object (table, index) in the buffer cache SELECT OBJECT_NAME(p.[object_id]) AS...
Comments