This is a simple script to run in your SQL Server instance to get plan reuse percent and know how much of your plans are used just one time and how much are used more often.

Output:

First line: Total

Second line: %

totalExec: Total of all your cached plans.

multipleExec: Total of all your cached plans that had been used more than once.

singleExec: Total of all your cached plans that had been used just once.

 

Hope it help you.