Using SQL Server on development machine
SQL Server is designed to use as much memory as it can to improve performance by caching lot of things in memory. If you are using that machine for active development or testing its good to limit SQL memory otherwise your machine might become slow. You can do the following to limit SQL Server memory. USE master EXEC sp_configure 'show advanced options', 1 RECONFIGURE WITH OVERRIDE -- limit to 1 gig of memory EXEC sp_configure 'max server memory (MB)', 1024 RECONFIGURE WITH OVERRIDE -- show all configs EXEC sp_configure