• That is the nature of SQL Server, It allocates as much as it needs.

    You can limit max memory SQL Server can use by configuring the min and max memory from either EM or sp_configure command.

    Use performance monitor to watch how SQL Server consumes memory and other system resources.