Is the SQL Plan Cache located in a certain Database? i.e. Master, msdb? Or just resides in Memory but not a specific Database per se?
We have this weird performance problem. It's possible SQL Server had a bad query plan. But I flushed the cache. So if I wanted to restore the bad query plan to do more analysis.