SQL Server comes with a feature called Query Store, which provides some performance details, including wait information. For more deeper diagnostic information there are a handful of third-party ...

It's the most critical part of performance-tuning SQL Server. If you are on a version of SQL Server older than 2016, you may want to look for a third-party performance tool to help you get this ...