Contents tagged with sqlserver

  • Limit SQL Server Memory Use on Dev Machine

    If you’re a developer running SQL Server locally, you may sometimes need to limit how much memory the database is consuming.  Under normal conditions, SQL Server likes to use as much memory as it can get, since keeping results in memory improves the database’s performance.  In typical production scenarios, this is the ideal behavior, but on a dev machine you probably want your RAM for other things.  In my case, I noticed my RAM was creeping up to over 9.5 GB and saw this: First of all, it’s somewhat telling that on my dev machine here, I’m not even running my dev environment, and my browser windows are collectively using more RAM than anything else (and what’s up with … more