Install SQL Cache Manager - SQL-FineBuild/Common GitHub Wiki

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

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 originally chosen to be included in FineBuild because it allows the DBA to view and manage the SQL Server Plan Cache. However, it has not been maintained for a number of years and cannot be installed on SQL2012 or above.

Item Location
SQL Cache Manager home page https://web.archive.org/web/20200724130731/https://archive.codeplex.com/?p=sqlservercache
SQL Cache Manager download https://web.archive.org/web/20210315172806/https://codeplexarchive.blob.core.windows.net/archive/projects/sqlservercache/sqlservercache.zip

After downloading from the web archive site, the following additional steps are needed to make the install media available:

  1. Browse the SQLServerCache.zip file

  2. Navigate to the \releases\1 folder

  3. Copy the 31801e2b-e4ae-47b0-a01c-f0f7dcd3db61 file to the \Additional Components folder

  4. Rename the 31801e2b-e4ae-47b0-a01c-f0f7dcd3db61 file to SQLServerCacheManagerInstallation1_0_0_4.zip

SQL Cache Manager can only be installed on SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

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:

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

After the install is complete, see the First Time of Use note

Top

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

    ![Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/CacheManager Explorer.png)

  2. Click on Unblock if this button is present

    Then click on OK

    ![Unblock](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/CacheManager Unblock.png)

  3. Right-click on SQLServerCacheManagerInstallation1_0_0_4.zip

    Select Extract All

    ![Extract](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/CacheManager Extract.png)

  4. The Welcome window is displayed

    Click Next to continue

    ![Welcome](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/CacheManager Welcome.png)

  5. Set the extract folder to C:\Program Files\SQLCacheManager

    Click Next to continue

    ![Install Location](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/CacheManager Location.png)

  6. Ensure Show extracted files is checked

    Click Finish to continue

    ![Complete](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/CacheManager Complete.png)

Setup Menu Item

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

  1. Right-click on setup.exe

    Select Copy

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

  2. Navigate to the Performance Tools menu

    Select Paste Shortcut

    Platform 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

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

  3. Right-click on Shortcut to setup and select Rename

    Rename the shortcut to SQL Cache Manager

    ![Rename Menu](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/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

    ![Firat Use](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/SQLCacheManager/CacheManager FirstTime.png)

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

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