You used some memory in the process due to the procedure and buffer caches. However that memory will be recovered as needed by SQL or the OS at some point. Most likely you make see SQL take a bit more memory and not free but that internally SQL will reutilize as needs be.