Which SQL Server database taking all memory ?

Publicado el: 31 agosto 2022
en el canal de: Vikash DBA (RDMS tutorial)-SQL GUIDE

408

Determine SQL Server memory use by database and object
How to List Dirty Pages From Memory in SQL Server?
How to View the Dirty Pages In Memory of a Database?

FOR PAID SQL TRAINING AND SUPPORT Pleases contact - vikashk.dba@gmail.com

Script:

--list all the dirty pages from the memory
SELECT db_name(database_id) AS 'Database',
page_id AS 'Dirty Pages',
FILE_ID,
page_type,
page_level
FROM sys.dm_os_buffer_descriptors
WHERE is_modified =1

---SQL Server which database takes all memory
--Determine SQL Server memory use by database and object
DECLARE @buffer INT;
SELECT @buffer = cntr_value
FROM sys.dm_os_performance_counters
WHERE RTRIM([object_name]) LIKE '%Buffer Manager'
AND counter_name = 'Total Pages';

;WITH buffer_descriptors AS
(
SELECT
database_id, db_buffer_pages = COUNT(*)
FROM sys.dm_os_buffer_descriptors
GROUP BY database_id
)
SELECT
DB_NAME([database_id]) as DB_Name ,
db_buffer_pages,
db_buffer_pages / 128 as db_buffer_MB
FROM buffer_descriptors
ORDER BY db_buffer_MB DESC;

En esta página del sitio puede ver el video en línea Which SQL Server database taking all memory ? de Duración hora minuto segunda en buena calidad , que subió el usuario Vikash DBA (RDMS tutorial)-SQL GUIDE 31 agosto 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 408 veces y le gustó 12 a los espectadores. Disfruta viendo!

874