May 23, 2019 at 2:16 am
how to calculate the RAM used while running a query, for example, I run the following code, how can I know the RAM used by this statement. thanks in advance!
select * from table1 t1 left join table2 t2
ON t1.f1=t2.f1 and t1.f2=t2.f2
where t1.f5='active'
May 24, 2019 at 8:18 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
May 25, 2019 at 3:40 am
thank you for your help!
Hoping to get an answer here.
September 15, 2020 at 12:51 am
Sorry for my bothering !
How to calculate the RAM used while running a query, for example, I run the following code, how can I know the RAM used by this statement. thanks in advance!
select * from table1 t1 left join table2 t2
ON t1.f1=t2.f1 and t1.f2=t2.f2
where t1.f5='active'
September 15, 2020 at 1:57 pm
(size of data table t1 + size of t2 join fields) * (number of rows in t2) ? SQL Server estimates it . Can be lower if data is streamed (max size for one record in table 1)
https://techcommunity.microsoft.com/t5/sql-server/understanding-sql-server-memory-grant/ba-p/383595
https://sqlperformance.com/2019/06/sql-memory/troubleshooting-variable-memory-grants
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply