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

Previous Install SQL Cache Manager Manual Install Install Master Data Services Next

Install SQL Internals Viewer

FineBuild can install and configure the SQL Internals Viewer as part of the SQL Server install process.

SQL Internals Viewer is 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.

SQL Internals Viewer home page http://internalsviewer.codeplex.com
SQL Internals Viewer download http://internalsviewer.codeplex.com
Rename the SQL 2005 download to InternalsViewerInstaller2005.msi
Rename the SQL 2008 download to InternalsViewerInstaller2008.msi
SQL Internals Viewer introduction http://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 tutorial http://internalsviewer.codeplex.com/wikipage?title=Resources

FineBuild SQL Internals Viewer Install

Automated silent installation of SQL Internals Viewer is performed by Process Id 4SE and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupIntViewer FULL Yes Yes N/A N/A N/A
SetupSQLTools No No No No No
SetupIntViewer WORKSTATION Yes Yes N/A N/A N/A
SetupSQLTools Yes Yes Yes Yes Yes
SetupIntViewer CLIENT Yes Yes N/A N/A N/A
SetupSQLTools Yes Yes Yes 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

Manual SQL Internals Viewer Install

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.
1) Navigate to the Additional Components folder and double-click on SqlInternalsViewerInstaller.msi.
IntViewer msi.png
2) The welcome window is displayed. Click Next to continue.
IntViewer Welcome.png
3) The install is complete. Click Close to end. The Internals Viewer is shown as a menu item within SQL Server Management Studio. It should automatically integrate into SSMS when SSMS is next started.
IntViewer Complete.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SQL Cache Manager Top Install Master Data Services Next

Last edited Oct 23, 2014 at 12:38 PM by EdVassie, version 21