This project has moved. For the latest updates, please go here.

Previous Install OLE Provider for DB2 Manual Install Install SQL Internals Viewer Next

Install SQL Cache Manager

FineBuild can install and configure the SQL Cache Manager as part of the SQL Server install process.

SQL Cache Manager is written by Blake Pell. It was chosen to be included in FineBuild because it allows the DBA to view and manage the SQL Server Plan Cache.

SQL Cache Manager home page http://sqlservercache.codeplex.com
SQL Cache Manager download http://sqlservercache.codeplex.com

FineBuild SQL Cache Manager Install

Automated silent installation of SQL Cache Manager is performed by Process Id 4SD and is controlled by the parameters below:

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

FineBuild also uses the following parameters to help install SQL Cache Manager:
Parameter Default Value Description
CacheManagerzip SQLServerCacheManagerInstallation1_0_0_4.zip Name of file holding SQL Cache Manager install media

The SQL Cache Manager 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 SQL Cache Manager includes the following:
  • Perform a SQL Cache Manager install
  • Add a menu item for SQL Cache Manager to the SQL Performance Tools menu.
  • See First Time of Use note

Manual SQL Cache Manager Install

The following steps show what you would have to do to install the SQL Cache Manager manually. FineBuild does all of this work for you automatically.

SQL Cache Manager Install

1) Navigate to the Additional Components folder. Right-click on SQLServerCacheManagerInstallation1_0_0_4.zip and select Properties.
CacheManager Explorer.png
2) Click on Unblock if this button is present, and then click on OK.
CacheManager Unblock.png
3) Right-click on SQLServerCacheManagerInstallation1004.zip and select Extract All_.
CacheManager Extract.png
4) The Welcome window is displayed. Click Next to continue.
CacheManager Welcome.png
5) Set the extract folder to C:\Program Files\SQLCacheManager then click Next.
CacheManager Location.png
6) Ensure Show extracted files is checked, then click Finish to continue.
CacheManager Complete.png

Setup Menu Item

Add a menu item for SQL Cache Manager to the Microsoft SQL Server menu structure, so that all tools for SQL Server are found in one place.

1) Right-click on setup.exe and select Copy.
CacheManager MenuCopy.png
2) Navigate to the Performance Tools menu and select Paste Shortcut.

OS Version Location
Windows 2003 and below C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft SQL Server 2008\Performance Tools
Windows 2008 and above C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008\Performance Tools

CacheManager MenuPaste.png
3) Right-click on Shortcut to setup and select Rename. Rename the shortcut to SQL Cache Manager.
CacheManager MenuRename.png

First Time of Use

The SQL Cache Manager Application is packaged as a OneClick package. This means that each person who uses it will receive a message on the first time they use it.

1) Click Install to continue.
CacheManager FirstTime.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install OLE Provider for DB2 Top Install SQL Internals Viewer Next

Last edited Oct 23, 2014 at 12:39 PM by EdVassie, version 11