Pages

Tuesday, October 30, 2012

SQL Server 2012 use all memory /memory leak

I have install SharePoint 2013 with Sql server 2012 for development and it run so slow. I found that Sql Server 2012 use alot of memory. It seem to be default how it behavior. There is a setting to lower it so there are free some memory for other application.

Use Sql Server Managment Studio and connect to sql server. Right click -> properties -> Memory and change Maximum server memory. In my case, i have 8 gig of ram. I put max is 3gig.