SolarWinds Database Performance Analyzer vs Spotlight

• Maintains historical SQL execution data, enabling forensic analysis
• Has the ability to slice and dice the data so that you can drill down to the execution of a single SQL statement being executed by a stored procedure
• Alerts to when the consumption pattern changes
• Shows historical average run times against the current, illustrating problems when they arise
• Provides tuning advice based on best practices

Read full review

• I love the main page that provides a color code list of all the servers so I know very quickly where to focus my attention first.
• I love how easy it is to configure new notifications.
• I love how easy it is to configure a new server to monitor.

Read full review

• Alerts seem to be lacking in DPA compared to competitor's tools. They can be setup but are not quite as easy or as helpful as some other tools I have used.
• Grooming/pruning the repository database isn't very easy. We don't manage a lot of instances but our repo DB has grown pretty significantly.
• At times when I am drilled-down to a chart, it can be difficult to navigate around from that point to another time range/query/metric.

Read full review

• Have not found any issues at this point.

Read full review

• I cannot provide quantitative data, but can give you some real positive impact example .
• We had several points in the Internet banking applications which do not work as well as desired. Using DPA we identified the heaviest SQL queries and initiate a change request to the vendor. After implementing the received changes we are able to reduce response time by an order of magnitude.

Read full review

• We have not encountered any issues and continue to keep Spotlight's version current.
• Very simple to set up and add databases. The only thing that has to happen to the database is that a user ID needs to exist.

Read full review