Project Description
This utility will allow you to return information about what is stored is the SQL Server cache and how efficiently it is being used. The utility allows you to query off of various criteria such as use count so you can see which queries execution plans are being reused and which aren't. It also will show you whether it's they are ad-hoc queries, prepared or stored procedures. This information can be handy when looking for queries in programs that need to be optimized.

This project was originally written with Visual Studio 2005 against the .Net Framework 2.0 but has been upgraded to Visual Studio 2008 and is now compiling against the .Net Framework 3.5 (nothing specific to 3.5 though so if needed the target framework could be easily changed). The source code was written in Visual Basic.

Screenshots:

SqlServerCacheManager.jpg
SqlServerCacheManager2.jpg

Last edited May 21, 2008 at 5:23 PM by bpell, version 5