Squishy Limits in SQL Server Express Editionhttp://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspxDo you use Express Edition? Then you might not know that the published memory limits are not set in stone.enCommunityServer 2.1 SP2 (Build: 61129.1)re: Squishy Limits in SQL Server Express Editionhttp://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspx#48453Thu, 28 Mar 2013 17:51:36 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48453ALZDBA<p>this may be an interesting case for your request.</p>
<p><a rel="nofollow" target="_new" href="http://dba.stackexchange.com/questions/33088/why-does-sql-server-2012-express-use-9-5gb-of-ram-on-my-server">http://dba.stackexchange.com/questions/33088/why-does-sql-server-2012-express-use-9-5gb-of-ram-on-my-server</a></p>
re: Squishy Limits in SQL Server Express Editionhttp://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspx#48480Mon, 01 Apr 2013 11:44:47 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48480KKline<p>Thanks Johan! Great addition to the discussion. &nbsp;-Kev</p>
re: Squishy Limits in SQL Server Express Editionhttp://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspx#54817Thu, 14 Aug 2014 15:35:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:54817Dean<p>Almost the same with SQL Server 2014 Express edition - the actual limit is 1,609MB.</p>
<p>BTW, we've recorded the result in a short video:</p>
<p><a rel="nofollow" target="_new" href="http://www.netometer.com/blog/?p=1451">http://www.netometer.com/blog/?p=1451</a></p>
<p>Dean</p>
re: Squishy Limits in SQL Server Express Editionhttp://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspx#54858Mon, 18 Aug 2014 11:48:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:54858KKline<p>Nice, Dean! Thanks for sharing. -Kev</p>
re: Squishy Limits in SQL Server Express Editionhttp://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspx#55123Tue, 09 Sep 2014 06:28:17 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:55123afatac<p>We have been using MS SQL Express 2008R2 with a digital asset management software system. Though only metadata and configuration settings are written to database, we are always concern about the 1GB limit.</p>
<p>Is there a way to monitor this usage of buffer cache over a period of time, so that we can decide if we need to upgrade to Standard version?</p>