Getting error:There is insufficient system memory in resource pool when executing Query

Question

When I run a stored procedure that does

truncate table TargetTable;

WITH TyreDimensionList as
(
       SELECT   

            col1,
            col2,
            col3


       FROM Table1  t1
        INNER JOIN Table2 t2
       ON t1.col1 = t2.col1

)

Insert into dbo.TargetTable
(
    col1,col2,col3
)
SELECT 

    col1,col2,col3
FROM TyreDimensionList

I get the german error: Nicht genügend Arbeitsspeicher im Pufferpool.

Which I think translates to: There is insufficient memory available in the buffer pool.

We recently upgraded the RAM of the server, so I think that this might be and hardware issue. The query inserts lots of rows (millions).

The error in query manager is different when I run the query: The error is printed in terse mode because there was error during formatting. I think it dos not help here.

Any idea how I can prove to my admin that this is a hardware issue or how I can check if its on my side?