DBAs are often asked to solve SQL Server performance issues that occurred in the past. And unless you’ve installed a SQL Server monitoring solution, you’re forced to rely on SQL Server’s data collection.
As you’ve probably discovered, SQL Server data collection has many limitations in terms of what it stores historically, what data exists and how data is not integrated together across the various areas of the product and its features.