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.

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 installation of System Views Map is performed by Process Id 4SH and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
InstSystemViews FULL Yes Yes Yes Yes Yes
InstSQLTools No No No No No
InstSystemViews WORKSTATION Yes Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes Yes
InstSystemViews CLIENT Yes Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes Yes

FineBuild also uses the following parameters to help install System Views Map:
Prameter 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:
/InstSQLTools:Yes
Note: A PDF Reader is required in order to view the System Views Map file.

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 - 2013 Edward Vassie. License and Acknowledgements
Previous Install SQL Performance Dashboard Top Install Notification Services Next

Last edited Aug 8, 2013 at 4:26 PM by EdVassie, version 14

Comments

No comments yet.