just take the properties of the database server in ssms and in options set max memory to e.g. 10 gb and it will acquire not more than that. if sql...