45 The capability to baseline the environment and define thresholds for alerting is definitely the most valuable feature in my opinion. Valuable Features:The capability to baseline the environment and define thresholds for alerting is definitely the most valuable feature in my opinion. As an operational DBA, I don't write code but need to make sure the SQL servers are healthy, performing scheduled jobs and made aware when issues arise.Improvements to My Organization:SQL monitoring time has been dramatically reduced AND our IT Infrastructure team has improved SQL maintenance and monitoring knowledge over time just by using SQL DM. The dashboard provides valuable health information at a glance and from there drilling in and finding the cause of issues is pretty straightforward. Our SQL server environment consists mainly of proprietary databases so it is vital that we are on top of performance, resources and job execution - SQL DM provides the view into all of this.Room for Improvement:With basic SQL training in my history, I've found at times I needed to Google SQL counters, for example, to understand what was occurring or how to configure SQL DM to be useful. While support has helped out, it's not their job to teach SQL! The built in help works for general configuration of the product but sometimes lacks the descriptions needed for fully understanding the intent of particular settings.Use of Solution:We first implemented version 4.X so at least 10 years.Deployment Issues:The original deployment was straightforward and upgrades have become more streamlined along the way.Stability Issues:In earlier versions we periodically needed to restart services but with each upgrade, stability has improved and I don't recall ever needing to restart the version we are using, which is a few versions behind at this point.Scalability Issues:Not at all. We easily moved from a SQL server that also contained the application to running the app on our Infrastructure app server and the database on a shared SQL server. Adding licenses and new servers to the SQL DM environment is simple.Customer Service:Although I haven't contacted customer service often, the response has always been prompt, courteous and provided for our needs. Additionally, Idera is very good at keeping the customer up to date on Account Manager changes.Technical Support:Tech support has been contacted only a few times but I found them to be prompt, knowledgeable and helpful in their responses. There is a level of SQL knowledge that I, as a relative beginner in the SQL world, found very helpful!Previous Solutions:No. We were floundering around with MS SQL counters, event logs, SQL trace and profiler and were basically in the dark.Initial Setup:Straightforward. Install the app and repository and if using the console from a different machine, ie. your workstation, install the console. Launch the app and start base-lining. Adjust thresholds based on your needs and build alerts. The configuration remains through upgrades.Implementation Team:We implemented in-house. It's a simple install and configuration is ongoing for the initial month or so until baselines are established and thresholds and alerts defined.Cost and Licensing Advice:License codes are provided by Account Managers and are required for installing or upgrading the product.Other Solutions Considered:We looked at MOM but were already invested in Solarwinds Network Performance Monitor at the time so decided not to go with MOM just for the SQL piece. While Solarwinds had SQL Application Monitor at the time it was not as easy to install, configure or understand as SQL DM.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
45 Overall analysis of data gathered from SQL Server needs work but it is easy to perform issue investigations Valuable Features:Ability to identify bottlenecks, deadlocks and slow running queries and run monthly and daily reports.Improvements to My Organization:It was easier for DBA team to perform issue investigations, slowness of the servers and failures.Room for Improvement:Reporting and overall analysis of data gathered from SQL Server.Use of Solution:One year.Deployment Issues:Minor. When we migrated to the new server, we had to call the company to transfer the license as their license is issued per server name which had changed..Stability Issues:No issues encountered.Scalability Issues:No issues encountered.Customer Service:Good.Previous Solutions:We recently switched to SolarWinds DPA 9.0 because it provides similar functions but with better pricing model.Initial Setup:It is straightforward.Other Advice:I would recommend this product - I liked it!Disclaimer: I am a real user, and this review is based on my own experience and opinions.