SQL plan cache snapshot

You can capture the information contained in the SQL plan cache by creating a snapshot. Creating a snapshot creates an instance of your plan cache that behaves very much like a detailed SQL performance monitor. You perform many of the same actions against a snapshot that you can using detailed SQL performance monitor data.