INFORMATICS

The Best

Przełącznik języka

BUY COFFEE

If you like the website and want to support the project!

Postaw mi kawę na buycoffee.to

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Uncategorised

useful sites

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

DNS

Antivirus program

Linux

Foto

Licznik

3.png0.png7.png0.png3.png1.png5.png
Today785
Yesterday1328
This week2830
This month20828
Total3070315

Visitor Info

  • IP: 3.135.209.20
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

6
Online
Monday, 23 December 2024 19:00
You are here: Home MSSQL scripts MSSQL SERVER – Script to Identify Memory Used By Each Database

MSSQL SERVER – Script to Identify Memory Used By Each Database

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
  
MSSQL SERVER – Script to Identify Memory Used By Each Database

-- Memory used by each database
SELECT DB_NAME(database_id),
COUNT (1) * 8 / 1024 AS MBUsed
FROM sys.dm_os_buffer_descriptors
GROUP BY database_id
ORDER BY COUNT (*) * 8 / 1024 DESC
GO

Search