Memory consumption for Query

How to check how much memory query is consuming.

Is there tool can check of query consuming memory for the execution or output.

Let's say for following query how to calculate memory consumption.

select * from test where id=1;

Sent from Outlook<http://aka.ms/weboutlook>