The major use case I have is that whenever there's any kind of complaint about the performance of the database, I can go in. I can go back to that time and see what was happening on the database at that time. I can see if we had a high CPU or high IO, or if the memory was too high. I can go back and find the plan of the SQL and tune it as necessary.

The primary use case of this solution is for troubleshooting performance issues, blocking issues, and deadlock issues.