We’ve used the same script that Kevin Kline posted on his blog: Naturally, with the release of SQL Server 2014 Express edition, it is interesting to check what is the actual memory limit. In a similar way the SQL Server Pro Kevin Kline confirmed that SQL Server 2012 Express Edition memory working set size can grow around 1.4-1.5GB. His post is in Polish, so you might have to use Google translate, but the script that he uses and the results are easy to interpret. In 2010, the SQL Server MVP Pawel Potasinski confirmed that SQL Server 2008 R2 Express edition, which has the same 1GB memory limit, can actually use about 1400MB of memory. The official SQL Server 2014 Express edition memory limit is 1GB per instance – that is, strictly speaking, the buffer cache restriction. Don’t be surprised if your SQL Server 2014 Express instance uses more than 1600MB memory
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |