Question: sql is taking all the memory?
Answer: SQL Server will consume as much memory as you will allow it. ... The reason for this is that SQL Server cache the data in the database in RAM so that it can access the data faster than it could if it needed to read the data from the disk every time a user needed it.