CA Service Management, with CA Service Desk Manager vs. SolarWinds Database Performance Analyzer

It is a suitable tool for a large organization with extensive user needs. It is not for a small shop as it may be over-engineered for smaller organizations that don't have teams that can manage a solution of this size. It does have some significant hardware and configuration needs, but that should not deter customers from deploying it in-house. I've seen it deployed in the cloud as well as in-house; the downside to deploying it as a hosted solution is you're forever at the mercy of the vendor for customizations, and they cost an arm and a leg. The simplest things take a long time and cost much more money than necessary, so you can't truly get a custom solution and end up with mostly vanilla services (unless you have very deep pockets.)

Incentivized

This is an easy 10 because I actually have recommended this product to multiple clients and colleagues! Any shop that writes its own SQL queries will benefit from the insight provided by SolarWinds Database Performance Analyzer, so they know which of their queries is causing a bottleneck. Small shops or databases with only a few tables likely will see far fewer opportunities for optimization.

Incentivized

• A large community where, if help is needed, is usually very helpful and quick to respond.
• Various sites with good information on various issues. If you have a problem, there's a good chance some else already had it and documented it.
• Fairly easy installation of the product if recommendations are followed and prep-work is done.

Incentivized

• 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

Incentivized

• The right-click feature is disabled in this application and users are unable to copy and paste with mouse or touchpad.
• The application also freezes quite a bit and a user will have to quite often close and reopen browser to get it functioning properly.

Incentivized

• 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.

Incentivized

While the concepts of Service Desk and EITM were solid. The user interface, tool capabilities, and integrations fell behind the rest of the industry. Too often it seemed like CA bought and rebranded products without fully integrated them with their other products. It was a coat of paint, without the parts under the hood being updated. The overhead for administration was too high and the reporting capabilities were absolutely amongst the worst I've seen.

Incentivized

We have relied on this product for a very long time and it continues to exceed expectations. The product is a vital part of our organization at this point, it would not be very ideal for us to abandon it. We use it almost every day and depend on its alerts for critical parts of our business

Incentivized

I don't want to think about managing clusters of SQL servers in the future without this tool. We have demoed other tools and SolarWinds Database Performance Analyzer is the gold standard for usability and insight into what your servers are doing. The UI is a bit dated, but everything is laid out in a logical manner and drilling down into queries or timeslices is extremely intuitive.

Incentivized

I have had to use their support on a few occasions, for reasons that I am not clear about until recently I have always had problems upgrading the software (although the last 2 updates have gone without issue which I am very pleased to say). On those unfortunate occasions, the support has been brilliant with either excellently documented guides on how to resolve the issue by myself or have been hands-on with calls and screen sharing to remotely fix the issue. Every time the problem was sorted and more importantly, nothing was lost (apart from a bit of time). And as I stated above whatever the problem was that was causing my upgrade issues appears to have been resolved in the last 2 updates.

Incentivized

Follow the guidelines for the capacity of the servers. We found that the DPA databases were getting rather large and also that there are ways to reduce their size built into some of the options.

Incentivized

We are too integrated with CA Service Desk Manager to disassociate anytime soon. We found the more we used the product the more we needed to customize it in order to better integrate with our business processes. There are other alternatives that have many built-in features that had we have foreseen our future requirements... would have chosen ServiceNow or Remedy as our "go-to" ticketing product.

Incentivized

At the time, we found SolarWinds Database Performance Analyzer to be easier to setup and to have a richer feature set than Redgate SQL Monitor, plus, from what I remember, the DPA pricing worked better for us over the course of a year. We're very happy with all the features DPA has to offer.

Incentivized

• Having CA Service Desk Manager within the company has increased the satisfaction of customer service from 68% to 95%. Teams are getting better customer survey scores and making better efforts to meet their SLAs.
• CA Mobile app has provided agility and collaboration among IT Users and Customers.

Incentivized

• It has allowed us to progress as an organization with much less reliance on a direct DBA than would traditionally be required
• Allowed us to be much more proactive in our performance monitoring and responding to issues that would affect users.

Incentivized