DIR Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
  HTML https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: Scripts
       *****************************************************
       #Post#: 25--------------------------------------------------
       Max Memory Setting Script on SQL Server Database Node
       By: srinivasma_exceldbp Date: March 18, 2014, 11:04 pm
       ---------------------------------------------------------
       /*
       Script  : Max Memory Setting Script on SQL Server Database Node
       Purpose:
       utilisation on a 64-bit environment
       This outputs sp_configure statements to set proper memory on sql
       server database system
       This helps dba to set memory automatically since all
       calculations are carried out in the script
       NOTE:  This is for single instance on server.
       If there are multiple instances are in the database node,
       take the value from ''max server memory'','+CONVERT(VARCHAR(6),
       @MaxMem)+'; and
       allocate to different instances depending on the load on each
       instance
       Applies to: SQL 2005, SQL 2008/R2, SQL 2012, SQL 2014
       */
       --=====================================================
       set nocount on;
       --=====================================================
       declare
       --@pg_size INT,
       @Instancename
       --@RecMem int,
       @MaxMem
       @MaxRamServer
       @sql
gopher.createaforum.com:70 /forums/esdbp/p/24:39: port field too long