Buffer Pool ExtensionKunal RanpuraJul 28, 20191 min read--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...
Comentarios