Idera SQL Products for the WIN!
What do you like best?
Currently utilizing SQL Doctor, SQL Defrag Manager, and SQL Diagnostic Manager and have ZERO complaints in regards to all three products. These solutions work seamlessly to provide complete overhead analysis and diagnosis of SQL performance issues to include index fragmentation, missing indexes, queries requiring optimization and server hardware issues just to name a few.
What do you dislike?
There is honestly nothing that I dislike at the moment. I have had no issues with installation, configuration or use since day one.
What problems are you solving with the product? What benefits have you realized?
Idera first pointed me to around 90 different indexes requiring rebuilds/reorgs in one of my production databases. Their solutions have also recommended query optimizations and SQL Server configuration changes that would best suit my environment.