MultiCloud Marketplace

RightScale

DB SQLS Configure TempDB (v14.0)

Open in Dashboard

Published by RightScale on Jun 05, 2013Revision: 10 This component has been superseded. Get the current version here

Description

Configures tempdb according to Microsoft recommendations (http://msdn.microsoft.com/en-us/library/ms175527.aspx):

  1. Sets recovery model to simple.
  2. Creates as many data files (of the same size) as the quantity of CPU cores on the system. Default size is 1 GB, but you can override this using OPT_TEMPDB_DATAFILE_SIZE_GB input.
  3. Sets the growth mode of data files to 10%.

Revisions

Revision 11 | Jul 22, 2013

Revision 10 | Jun 05, 2013

Revision 9 | Feb 04, 2013

Revision 8 | Jan 10, 2013

Revision 7 | Oct 05, 2012

Revision 5 | Sep 07, 2012

Revision 4 | Apr 05, 2012

Revision 3 | Jan 12, 2012

Revision 2 | Dec 01, 2011

Revision 1 | Jun 04, 2011

Pricing

All Users

Sign-up for RightScale

Support Information

http://support.rightscale.com/ServerTemplates