"You can also go for a third party tool for the same purpose"

Why? SQL Server has some reporting built into it. 😎

And can you be certain that the tool you've selected accurately reports on the problem?

I like the other answer that gives me a script more than a tool because you get to dig into what's going on. As soon as the tool company raises prices to where you can't buy them or it goes out of business, you're out of business. Have to take the time to learn these internals. More I look around, the more I see folks dependent on tools and not understanding what goes on underneath. It's a big reason why I love this site. We dig in here.