Install Troubleshooting Guide
| Previous Install SQL Nexus | Manual Install | Install XML Notepad Next |
|---|
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.
The Troubleshooting Guide is only available for SQL 2012 and below. There are better resources available on the internet for more recent versions of SQL Server.
| Item | Location |
|---|---|
| Troubleshooting Guide download | The Troubleshooting Guide is included in the FineBuild media |
| The SQL 2005 version was downloaded from https://web.archive.org/web/20190507154102/https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc966540(v=technet.10) and saved as a PDF file | |
| The SQL 2008 version was downloaded from https://web.archive.org/web/20200724131635/https://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docx and saved as a PDF file |
Automated silent installation of Troubleshooting Guide is performed by Process Id 4TH and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupTrouble: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2017 | /SetupTrouble: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2016 | /SetupTrouble: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2014 | /SetupTrouble: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2012 | /SetupTrouble: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008R2 | /SetupTrouble: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008 | /SetupTrouble: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2005 | /SetupTrouble: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes |
In order to maintain compatibility with older versions of SQL FineBuild, the parameters /InstTrouble: and /InstSQLTools: can also be used.
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
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 |
The FineBuild install for Troubleshooting Guide includes the following:
The following steps show what you would have to do to install Troubleshooting Guide manually. FineBuild does all of this work for you automatically.
-
Navigate to the following file
Right-click and select _Copy
SQL Version Location SQL 2005 FineBuild\Build Scripts\Troubleshooting Performance Problems 2005.pdf All other versions FineBuild\Build Scripts\Troubleshooting Performance Problems 2008.pdf 
-
Navigate to the relevant destination folder
Select Paste
SQL Version Location SQL 2012 /VolProg:\Program Files\Microsoft SQL Server\110\Tools\Books SQL 2008 R2 /VolProg:\Program Files (X86)\Microsoft SQL Server\100\Tools\Books SQL 2008 /VolProg:\Program Files (X86)\Microsoft SQL Server\100\Tools\Books SQL 2005 X86 /VolProg:\Program Files\Microsoft SQL Server\90\Tools\Books SQL 2005 X64 /VolProg:\Program Files\Microsoft SQL Server (x86)\90\Tools\Books 
-
Highlight the Troubleshooting Performance Problems file
Right-click and select Copy
-
Navigate to the SQL Server Tutorials menu folder on C:
Select Paste Shortcut
-
Rename the menu shortcut to Troubleshooting Performance Problems
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous Install SQL Nexus | Top | Install XML Notepad Next |
|---|