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.
Comments