This project has moved. For the latest updates, please go here.

Previous Install SQL Nexus Manual Install Install XML Notepad Next

Install Troubleshooting Guide

FineBuild can install and configure the Troubleshooting Guide as part of the SQL Server install process.
If you do not want to include the Troubleshooting Guide in your FineBuild install, then do not download it.

Troubleshooting Guide is written by Microsoft. It was chosen to be included in FineBuild because it provides Microsoft best practice information on troubleshooting problems with SQL Server.

Troubleshooting Guide home page http://support.microsoft.com/kb/982870
Troubleshooting Guide download The Troubleshooting Guide is included in the FineBuild media
The SQL 2005 version was downloaded from http://technet.microsoft.com/en-us/library/cc966540.aspx and saved as a PDF file
The SQL 2008 version was downloaded from http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docx and saved as a PDF file

FineBuild Troubleshooting Guide Install

Automated silent installation of Troubleshooting Guide is performed by Process Id 4TH and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
SetupTrouble FULL Yes Yes Yes Yes Yes
SetupSQLTools No No No No No
SetupTrouble WORKSTATION Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupTrouble CLIENT Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameters InstTrouble and InstSQLTools can also be used.

FineBuild also uses the following parameters to help install Troubleshooting Guide:
Parameter SQL Version Default Value Description
TroublePDF SQL 2005 Troubleshooting Performance Problems SQL2005.pdf Name of Troubleshooting Guide file
TroublePDF SQL 2008 and above Troubleshooting Performance Problems SQL2008.pdf Name of Troubleshooting Guide file

Troubleshooting Guide will only be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
/SetupSQLTools:Yes
The FineBuild install for Troubleshooting Guide includes the following:
  • Perform a Troubleshooting Guide install
  • Add a menu item for Troubleshooting Guide to the Tutorials menu.

Manual Troubleshooting Guide Install

The following steps show what you would have to do to install Troubleshooting Guide manually. FineBuild does all of this work for you automatically.

Troubleshooting Guide Install

1) Navigate to the following file, right-click and select Copy

SQL 2005 FineBuild\Build Scripts\Troubleshooting Performance Problems 2005.pdf
All other versions FineBuild\Build Scripts\Troubleshooting Performance Problems 2008.pdf

TroubleCopy.png
2) Navigate to the relevant destination folder and select Paste

SQL 2005 X86 DrvProg:\Program Files\Microsoft SQL Server\90\Tools\Books
SQL 2005 X64 DrvProg:\Program Files\Microsoft SQL Server (x86)\90\Tools\Books
SQL 2008 DrvProg:\Program Files (X86)\Microsoft SQL Server\100\Tools\Books
SQL 2008 R2 DrvProg:\Program Files (X86)\Microsoft SQL Server\100\Tools\Books
SQL 2012 DrvProg:\Program Files\Microsoft SQL Server\110\Tools\Books
SQL 2014 DrvProg:\Program Files\Microsoft SQL Server\120\Tools\Books

TroublePaste.png
!!!Setup Menu Short-cut
1) Highlight the Troubleshooting Performance Problems file, then right-click and select Copy
TroubleMenuCopy.png
2) Navigate to the SQL Server Tutorials menu folder on C: and select Paste Shortcut
TroubleMenuPaste.png
3) Rename the menu shortcut to Troubleshooting Performance Problems.
TroubleMenuRename.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SQL Nexus Top Install XML Notepad Next

Last edited Oct 23, 2014 at 12:25 PM by EdVassie, version 6