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

Previous Install SQL Performance Dashboard Manual Install Install Notification Services Next

Install System Views Map

FineBuild can install and configure the SQL System Views Map as part of the SQL Server install process.

System Views Map is produced by Microsoft. It was chosen to be included in FineBuild because it provides a visual summary of the key system views included in SQL Server and the relationships between them.

You must also Install PDF Reader or a similar product in order to view the System Views Map.

SQL Server 2014 System Views Map No SQL 2014 download is currently available. Use the SQL 2012 download
SQL Server 2012 System Views Map home page http://www.microsoft.com/en-gb/download/details.aspx?id=39083
SQL Server 2012 System Views Map download http://www.microsoft.com/en-gb/download/details.aspx?id=39083 Download the PDF version
SQL Server 2008 R2 System Views Map home page http://www.microsoft.com/download/en/details.aspx?id=722
SQL Server 2008 R2 System Views Map download http://www.microsoft.com/download/en/details.aspx?id=722 Download the PDF version
SQL Server 2008 System Views Map home page http://www.microsoft.com/download/en/details.aspx?id=9301
SQL Server 2008 System Views Map download http://www.microsoft.com/download/en/details.aspx?id=9301 Download the PDF version
SQL Server 2005 System Views Map home page http://www.microsoft.com/download/en/details.aspx?id=14606
SQL Server 2005 System Views Map download http://www.microsoft.com/download/en/details.aspx?id=14606 Download the PDF version

A System Views Map printed copy can be obtained from some of the sponsors shown on the PDF document. A charge may be made for this.

FineBuild System Views Map Install

Automated silent installation of System Views Map is performed by Process Id 4SH and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSystemViews FULL Yes Yes Yes Yes Yes
SetupSQLTools No No No No No
SetupSystemViews WORKSTATION Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupSystemViews 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 InstSystemViews and InstSQLTools can also be used.

FineBuild also uses the following parameters to help install System Views Map:
Parameter SQL Version Default Value Description
SystemViewsPDF SQL 2014 SQL_Server_2012_System_Views_Map.pdf Name of System Views Map file
SystemViewsPDF SQL 2012 SQL_Server_2012_System_Views_Map.pdf Name of System Views Map file
SystemViewsPDF SQL 2008 R2 SQL_Server_2008R2_System_Views_Map.pdf Name of System Views Map file
SystemViewsPDF SQL 2008 SQL_Server_2008_System_Views_Poster.pdf Name of System Views Map file
SystemViewsPDF SQL 2005 SQL2005_Sys_Views.pdf.pdf Name of System Views Map file

The System Views Map 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 FineBuild install for System Views Map includes the following:
  • Perform a System Views Map install, for the PDF version
  • Add a menu item for System Views Map to the Documentation and Tutorials menu

Manual System Views Map Install

The following steps show what you would have to do to install the System Views Map manually. FineBuild does all of this work for you automatically.

System Views Map Install

1) Navigate to the Additional Components folder and copy

SQL Version Source File Destination
SQL 2014 64-bit SQL_Server_2012_System_Views_Map.pdf E:\Program Files (x86)\Microsoft SQL Server\100\Tools\Books
SQL 2012 32-bit SQL_Server_2012_System_Views_Map.pdf E:\Program Files\Microsoft SQL Server\100\Tools\Books
SQL 2012 64-bit SQL_Server_2012_System_Views_Map.pdf E:\Program Files (x86)\Microsoft SQL Server\100\Tools\Books
SQL 2008 R2 32-bit SQL_Server_2008R2_System_Views_Map.pdf E:\Program Files\Microsoft SQL Server\100\Tools\Books
SQL 2008 R2 64-bit SQL_Server_2008R2_System_Views_Map.pdf E:\Program Files (x86)\Microsoft SQL Server\100\Tools\Books
SQL 2008 32-bit SQL_Server_2008_System_Views_Poster.pdf E:\Program Files\Microsoft SQL Server\100\Tools\Books
SQL 2008 64-bit SQL_Server_2008_System_Views_Poster.pdf E:\Program Files (x86)\Microsoft SQL Server\100\Tools\Books
SQL 2005 32-bit SQL2005_Sys_Views.pdf.pdf E:\Program Files\Microsoft SQL Server\90\Tools\Books
SQL 2005 64-bit SQL2005_Sys_Views.pdf.pdf E:\Program Files (x86)/Microsoft SQL Server\90\Tools\Books

SystemViews Copy.png

Setup System Views Map menu item

Setup Menu Short-cut.

1) Highlight the System Views Map file, then right-click and select Copy.
SystemViews MenuCopy.png
3) Navigate to the SQL Server Documentation menu folder on C: and select Paste Shortcut.
SystemViews MenuPaste.png
4) Rename the menu shortcut

SQL Version Shortcut Name
SQL 2014 SQL 2014 System Views
SQL 2012 SQL 2012 System Views
SQL 2008 R2 SQL 2008 R2 System Views
SQL 2008 SQL 2008 System Views
SQL 2005 SQL2005 System Views

SystemViews MenuRename.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SQL Performance Dashboard Top Install Notification Services Next

Last edited Oct 23, 2014 at 12:33 PM by EdVassie, version 16