Friday, June 13, 2014

Set RAM limit to SBS internal database

Open SQL Server Management Studio

Connect to server name:
\\.\pipe\mssql$microsoft##ssee\sql\query

Right click the root node, click Properties
Click Memory
Change the value of Maximum server memory (in MB)