Foglight is a database performance management suite from Quest, with modules to perform cloud analytics, network performance monitoring and virtualization management, scaling to a broad, cloud / virtualization focused IT infrastructure monitoring solution.
It really depends on why my colleague is evaluating Foglight. If it is for Database monitoring and management, I highly recommend it. If it is for anything else, I would encourage them to look at others in this space.
Foglight allows detecting and diagnosing performance problems simplifying hybrid environments, it is a solution that has perfect features which work in a flexible and intuitive way, it allows database performance in a safe and fast way. It works perfectly with nothing else to add.
Foglight was chosen years ago as a replacement for Groundwork. After 2.5 years of implementing Groundwork things were still not complete and the decision to go with a more formalized solution was made. Foglight installed easily and quickly nearly across the board and the full implementation for complex infrastructure was completed (with no Professional Services) by us in under 4 months. Nagios is a wonderful toolkit but you have to be ready to build what you need. It's flexibility and breadth are excellent features but with that comes the need to define things very tightly lest you embark on the project that never ends (see above about Groundwork). Dynatrace is an excellent APM tool and has advanced analytics but as a general infrastructure monitoring tool it is actually very expensive and to be honest does not have the same focus and full feature set that it does on it's APM (which to be fair is it's wheelhouse). vROPs (we also have) is a wonderful tool but focused (and rightly so) on satisfying the VMware engineers in the crowd and doesn't put itself out there too far to make things palatable for the non-engineering crowd.