Knowledgebase
Knowledgebase:
SBS 2011 sbsmonitoring Sql server memory allocation
Posted by Russ Richards on 26 August 2014 01:10 PM
  1. On the SBS 2008 server, open the Start menu and select All Programs.
  2. Select Microsoft SQL Server 2005.
  3. Right-Click on SQL Server Management Studio Express and select Run As Administrator. If you don’t run the tool as Administrator, the remaining steps will not work.
  4. Select the database from the drop-down list, or enter it as servernameSBSMONITORING, then click Connect.
  5. When the Object Explorer window opens, right-click on the top item (servernameSBSMONITORING) and select Properties.
  6. Click on the Memory page in the left-hand column.
  7. Change the Maximum Server Memory value to something a little more reasonable (100 has been bantered around as a reasonable value, but you may need to adjust depending on the server performance).
  8. Click OK and the database memory usage will be adjusted.
  9. Close SQL Server Management Studio Express when finished.
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).