Install System Views Map - SQL-FineBuild/Common GitHub Wiki

Previous Install SQL Performance Dashboard Manual Install Install Notification Services Next

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.

System Views Map is not available for SQL 2014 and above. If you install the System Views Map you must also Install PDF Reader or a similar product in order to view it.

Item Location (always download the PDF version)
SQL Server 2014 and above No System Views Map is available for these versions of SQL Server
SQL Server 2012 System Views Map download https://www.microsoft.com/en-gb/download/details.aspx?id=39083
SQL Server 2008 R2 System Views Map download https://www.microsoft.com/download/en/details.aspx?id=722
SQL Server 2008 System Views Map download https://www.microsoft.com/download/en/details.aspx?id=9301
SQL Server 2005 System Views Map download The download for the SQL 2005 System Views Map is no longer available

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:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupSystemViews: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2017 /SetupSystemViews: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2016 /SetupSystemViews: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2014 /SetupSystemViews: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2012 /SetupSystemViews: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2008R2 /SetupSystemViews: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2008 /SetupSystemViews: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2005 /SetupSystemViews: Yes Yes Yes
/SetupSQLTools: No 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 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:

Top

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

    Copy the System Views Map file as described below:

    Platform Source File Destination
    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

: ![](Install System Views Map_SystemViews Copy.png)

Setup System Views Map Menu Item

Setup a Menu item for the System Views Map in the Documentation and Tutorials menu

  1. Highlight the System Views Map file

    Right-click and select Copy

    ![Menu Copy](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SystemViewsMap/SystemViews MenuCopy.png)

  2. Navigate to the SQL Server Documentation menu folder on C:\

    Select Paste Shortcut

    ![Menu Paste](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SystemViewsMap/SystemViews MenuPaste.png)

  3. Rename the menu shortcut

    SQL Version Shortcut Name
    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

    ![Menu Rename](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SystemViewsMap/SystemViews MenuRename.png)

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install SQL Performance Dashboard Top Install Notification Services Next