Install SQL Internals Viewer
| Previous Install SQL Cache Manager | Manual Install | Install Master Data Services Next |
|---|
FineBuild can install and configure the SQL Internals Viewer as part of the SQL Server install process.
SQL Internals Viewer was written by Danny Gould. It was chosen to be included in FineBuild because it provides a SQL monitoring tool that looks into the SQL Server storage engine and database internals to see how data is physically allocated, organised and stored.
| Item | Location |
|---|---|
| SQL Internals Viewer home page | https://web.archive.org/web/20180501070057/https://archive.codeplex.com/?p=internalsviewer |
| SQL Internals Viewer download | https://internalsviewer.codeplex.com |
| SQL Internals Viewer introduction |
https://www.sqlservercentral.com/articles/Product+Reviews/3200/ The screenshots are from the original stand-alone version, not the current SSMS integrated version |
| SQL Internals Viewer User Guide | https://web.archive.org/web/20170116110245mp_/http://internalsviewer.codeplex.com/wikipage?title=User%20Guide&referringTitle=Home |
After downloading from the web archive site, the following additional steps are needed to make the install media available:
-
Browse the InternalsViewer.zip file
-
Navigate to the InternalsViewer.zip\releases\6 folder
-
Copy the 63a5bb29-1659-4fe3-b0da-6c10efb27f5a file to the \Additional Components folder
-
Rename the 63a5bb29-1659-4fe3-b0da-6c10efb27f5a file to InternalsViewerInstaller2008.msi
-
Copy the e544338c-5524-4212-b307-970aedb4a76c file to the \Additional Components folder
-
Rename the e544338c-5524-4212-b307-970aedb4a76c file to InternalsViewerInstaller2005.msi
SQL Internals Viewer can only be installed for SQL 2008 and SQL 2005.
Automated silent installation of SQL Internals Viewer is performed by Process Id 4SE and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupIntViewer: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2017 | /SetupIntViewer: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2016 | /SetupIntViewer: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2014 | /SetupIntViewer: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2012 | /SetupIntViewer: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008R2 | /SetupIntViewer: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008 | /SetupIntViewer: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2005 | /SetupIntViewer: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes |
In order to maintain compatibility with older versions of SQL FineBuild, the parameters /InstIntViewer: and /InstSQLTools: can also be used.
FineBuild also uses the following parameters to help install SQL Internals Viewer:
| Parameter | SQL Version | Default Value | Description |
|---|---|---|---|
| /IntViewermsi: | SQL 2008 | InternalsViewerInstaller2008.msi | Name of SQL Internals Viewer install file |
| /IntViewermsi: | SQL 2005 | InternalsViewerInstaller2005.msi | Name of SQL Internals Viewer install file |
SQL Internals Viewer can only be installed for SQL 2008 and SQL 2005.
The SQL Internals Viewer will 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 following steps show what you would have to do to install the SQL Internals Viewer manually. FineBuild does all of this work for you automatically.
-
Navigate to the Additional Components folder
Double-click on SqlInternalsViewerInstaller.msi
-
The Welcome window is displayed
Click Next to continue
-
The install is complete
Click Close to end. The Internals Viewer is shown as a menu item within SQL Server Management Studio, and it should automatically integrate into SSMS when SSMS is next started
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous Install SQL Cache Manager | Top | Install Master Data Services Next |
|---|