how to calculate the RAM used while running a query

Question

how to calculate the RAM used while running a query

quellpress

SSC Enthusiast

Points: 112
More actions
October 22, 2023 at 3:53 pm

#4312895

how to calculate the RAM used while running a query

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

You can always see the estimated memory allocation in the execution plan. An actual memory allocation is possible if you capture runtime metrics with the execution plan, also called an "actual plan". The information is in the properties of the first operator on the left side of the plan.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 2

If you know the SPID for the query, you could also query the following DMV. Look for the word "memory" in the documentation.

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)