SQL Server memory Utilization

Question

Question:

How to I get memory utilization by SQL-server ?

What I have tried:

I am using, below select query

SELECT * FROM sys.dm_os_process_memory

for getting my answer but it not gives the exact memory value which used by SQL-server .

Code and Text formatting – Geeky Ninja Jul 31 '17 at 07:15 — Geeky Ninja, Jul 31 '17 at 07:15

peev · Answer 1 · 2017-07-31T06:59:21.327

0

Hello and welcome to DX. You can be more descriptive in your question in order to receive a good and accurate answer.

As far as I understand - I can propose you to use the Reporting capabilities ot SQL Server: Go to SQL Server Management Studio -> right click on the desired DB -> Reports -> Custom Reports -> Disk usage, etc. This is per database reporting.

As for the RAM usage you can browse here: How much RAM is SQL Server actually using?

edited Jul 31 '17 at 06:59

answered Jul 31 '17 at 06:52

peev

302
3
13

Disk usage <> RAM usage – Lukasz Szozda Jul 31 '17 at 06:55
Sir, i want SQLserver.exe memory utilization by SQL query or by c# programming. – Priyanshu Agrawal Jul 31 '17 at 13:22

SQL Server memory Utilization

1 Answers1