SQLTeam.com | Weblogs | Forums

Query measurement


#1

Hello all,

In SQL world, is there a way we can measure how much memory will be used to run a certain query(s) ? for example: I have a small basic query and I want to find out how much memory needed to run it? Anyone knows the query I can use to measure the memory usage?

Thank you all


#2

sys.dm_exec_query_stats