Install SQL Cache Manager
| 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:
-
Browse the SQLServerCache.zip file
-
Navigate to the \releases\1 folder
-
Copy the 31801e2b-e4ae-47b0-a01c-f0f7dcd3db61 file to the \Additional Components folder
-
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.
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
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.
-
Navigate to the Additional Components folder
Right-click on SQLServerCacheManagerInstallation1_0_0_4.zip and select Properties
-
Click on Unblock if this button is present
Then click on OK
-
Right-click on SQLServerCacheManagerInstallation1_0_0_4.zip
Select Extract All
-
The Welcome window is displayed
Click Next to continue
-
Set the extract folder to C:\Program Files\SQLCacheManager
Click Next to continue
-
Ensure Show extracted files is checked
Click Finish to continue
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.
-
Right-click on setup.exe
Select Copy
-
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 
-
Right-click on Shortcut to setup and select Rename
Rename the shortcut to SQL Cache Manager
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.
-
Click Install to continue
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous Install OLE Provider for DB2 | Top | Install SQL Internals Viewer Next |
|---|