This project has moved and is read-only. For the latest updates, please go here.

Previous Site Level Default Values Lightweight Server Role Next

Workhorse Server Role

This page describes the Workhorse Server Role SQL FineBuild deployment file.

The assumptions relating to this role are:
  • The operating system has use of 128 GB RAM and 32 processor cores, and may be running as a guest server
  • A separate drive letter is used for each type of database file
  • SQL Server is the only software installed, apart from installation-standard anti-virus and monitoring tools
  • The SSRS Unattended Execution account is required
  • The xp_cmdshell proxy account is required
  • Some of the servers created within this role require the replication Distributor database
  • SQL client tools are not required
  • Java connectivity is required
  • A Buffer Pool extension file is required if SQL2014 is installed
  • A number of servers will be created using this role
1) Create a role file in the Site SQL Files Folder similar to the example below. Call the file SQLWorkhorse.bat.
REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
REM
CALL "SQLProd.bat" %*       /Type:Full             ^
 /IAcceptLicenseTerms       /Edition:Enterprise    ^
 /VolDataAs:L /VolLogAs:M   /VolBackupAS:J         ^
 /VolData:GF  /VolDataFS:F  /VolDataFT:F /VolLog:H ^
 /VolTemp:T   /VolTempLog:U /VolBackup:J           ^
 /SetupCmdShell:Yes /SetupRSExec:Yes    /SetupSQLTools:No /SetupJavaDBC:Yes ^
 /SetupBPE:Yes /VolBPE:T /BPEFile:400GB

The role file contains all the parameters that define the role. All servers built using this role will use Enterprise Edition of SQL Server. If SQL2014 or above is installed, the BPE file will be created, otherwise these parameters will be ignored.

2) Create an install file for each server similar to the example below. Call the file PDGB01SQLS0020.bat, for use with server PDGB01SQLS0020
REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
REM
CALL “SQLWorkhorse.bat” %*                         ^
 /IAcceptLicenseTerms  /Server:PDGB01SQLS0020      ^
 /SAPWD:”UseAL0ngPa55phrase!”                      ^
 /SQLSVCAccount:”ROOT\ServGB_SQLDB_0001”           ^
  /SQLSVCPassword:”Argyt$6hsGGWMP894s4Gw2b73GS2o0” ^
 /AGTSVCACCOUNT:”ROOT\ServGB_SQLAG_0001”           ^
  /AGTSVCPASSWORD:”F6tbmd*nf!dfGFrcQnm84g4K7zwq2j” ^
 /ASSVCACCOUNT:”ROOT\ServGB_SQLAS_0001”            ^
  /ASSVCPASSWORD:”kE44bmutFGS579*bssJW84f=Rb6ehj”  ^
 /FTSVCACCOUNT:”ROOT\ServGB_SQLFT_0001”            ^
  /FTSVCPASSWORD:”w$Yhfb84nmkl5r*hsdFR7yNs2$ynd6”  ^
 /ISSVCACCOUNT:”ROOT\ServGB_SQLIS_0001”            ^
  /ISSVCPASSWORD:”bSHG5iuf9DFF#dw2!F5sKSIw43tnb7”  ^
 /RSSVCACCOUNT:”ROOT\ServGB_SQLRS_0001”            ^
  /RSSVCPASSWORD:”Orfd450!#DTWjn63hw45JDD873hk84”  ^
 /CmdshellAccount:”ROOT\AppGB_SQLCS_0001”          ^
  /CmdshellPassword:”j25Fb*ef$36ySIyBW7hZ”         ^
 /RSEXECACCOUNT:”PROD\APPGB_SQLRS_0001”            ^
  /RSEXECPASSWORD:”Prf53g#fdf$Efbv8QGH3”           ^
 /SetupDistributor:Yes

The install file contains the parameters unique to the server, such as the account names and server name.

3) Create similar install files for each of the other servers that will use this role. The /SetupDistributor: parameter should only be included for those servers that will act as a replication distributor.

4) When each install file is run, it runs the role file to pick up the standard role parameters. The role file then runs the environment default values file which in turn invokes FineBuild with the combined set of parameters.

Copyright FineBuild Team © 2014 - 2016. License and Acknowledgements
Previous Site Level Default Values Top Lightweight Server Role Next

Last edited Nov 11, 2016 at 12:19 PM by EdVassie, version 5