What users are saying about
Top Rated
162 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100
65 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100

Feature Set Ratings

    SQL Performance Monitoring

    8.1

    SolarWinds SQL Sentry

    81%

    SolarWinds Task Factory

    Feature Set Not Supported
    N/A
    SolarWinds SQL Sentry ranks higher in 5/5 features

    Performance dashboard

    9.0
    90%
    102 Ratings
    N/A
    0 Ratings

    Intelligent alerting

    8.0
    80%
    96 Ratings
    N/A
    0 Ratings

    Top SQL

    8.6
    86%
    102 Ratings
    N/A
    0 Ratings

    Historical trend data

    8.2
    82%
    100 Ratings
    N/A
    0 Ratings

    Virtualization support

    7.8
    78%
    64 Ratings
    N/A
    0 Ratings

    Data Source Connection

    SolarWinds SQL Sentry

    Feature Set Not Supported
    N/A
    9.0

    SolarWinds Task Factory

    90%
    SolarWinds Task Factory ranks higher in 1/1 features

    Connect to traditional data sources

    N/A
    0 Ratings
    9.0
    90%
    40 Ratings

    Data Transformations

    SolarWinds SQL Sentry

    Feature Set Not Supported
    N/A
    8.9

    SolarWinds Task Factory

    89%
    SolarWinds Task Factory ranks higher in 2/2 features

    Simple transformations

    N/A
    0 Ratings
    8.5
    85%
    39 Ratings

    Complex transformations

    N/A
    0 Ratings
    9.4
    94%
    35 Ratings

    Data Governance

    SolarWinds SQL Sentry

    Feature Set Not Supported
    N/A
    9.4

    SolarWinds Task Factory

    94%
    SolarWinds Task Factory ranks higher in 2/2 features

    Integration with data quality tools

    N/A
    0 Ratings
    9.5
    95%
    2 Ratings

    Integration with MDM tools

    N/A
    0 Ratings
    9.4
    94%
    3 Ratings

    Attribute Ratings

    • SolarWinds SQL Sentry is rated higher in 2 areas: Likelihood to Renew, Implementation Rating
    • SolarWinds Task Factory is rated higher in 1 area: Usability
    • SolarWinds SQL Sentry and SolarWinds Task Factory are tied in 2 areas: Likelihood to Recommend, Support Rating

    Likelihood to Recommend

    8.7

    SolarWinds SQL Sentry

    87%
    102 Ratings
    8.7

    SolarWinds Task Factory

    87%
    40 Ratings

    Likelihood to Renew

    8.8

    SolarWinds SQL Sentry

    88%
    16 Ratings
    8.2

    SolarWinds Task Factory

    82%
    3 Ratings

    Usability

    9.0

    SolarWinds SQL Sentry

    90%
    12 Ratings
    9.1

    SolarWinds Task Factory

    91%
    1 Rating

    Availability

    7.1

    SolarWinds SQL Sentry

    71%
    4 Ratings

    SolarWinds Task Factory

    N/A
    0 Ratings

    Performance

    7.1

    SolarWinds SQL Sentry

    71%
    4 Ratings

    SolarWinds Task Factory

    N/A
    0 Ratings

    Support Rating

    9.1

    SolarWinds SQL Sentry

    91%
    20 Ratings
    9.1

    SolarWinds Task Factory

    91%
    1 Rating

    In-Person Training

    8.0

    SolarWinds SQL Sentry

    80%
    1 Rating

    SolarWinds Task Factory

    N/A
    0 Ratings

    Implementation Rating

    8.5

    SolarWinds SQL Sentry

    85%
    18 Ratings
    8.2

    SolarWinds Task Factory

    82%
    2 Ratings

    Configurability

    7.9

    SolarWinds SQL Sentry

    79%
    2 Ratings

    SolarWinds Task Factory

    N/A
    0 Ratings

    Ease of integration

    5.0

    SolarWinds SQL Sentry

    50%
    1 Rating

    SolarWinds Task Factory

    N/A
    0 Ratings

    Product Scalability

    7.0

    SolarWinds SQL Sentry

    70%
    1 Rating

    SolarWinds Task Factory

    N/A
    0 Ratings

    Vendor post-sale

    8.5

    SolarWinds SQL Sentry

    85%
    2 Ratings

    SolarWinds Task Factory

    N/A
    0 Ratings

    Vendor pre-sale

    8.5

    SolarWinds SQL Sentry

    85%
    2 Ratings

    SolarWinds Task Factory

    N/A
    0 Ratings

    Likelihood to Recommend

    SolarWinds

    This solution is perfect for a team with a large server count and, at least, moderate experience supporting a SQL Server environment. If the environment is smaller or the team has less experience working with SQL Server performance tuning methodologies, then the tool may be overwhelming for the users.
    Read full review

    SolarWinds

    Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time.
    Read full review

    Pros

    SolarWinds

    • The Top SQL functionality has been extremely useful for identifying poorly performing queries by resource consumption.
    • The flexibility of creating your own Advisory Conditions has allowed us to integrate our custom internal alerts into a centralized dashboard and alerting platform.
    • Being able to highlight any chart on the dashboard and then tool-matching that window across all the other charts makes it much easier to correlate the different performance metrics against each other.
    Read full review

    SolarWinds

    • The single most beneficial component to Task Factory is the Upsert component. If you're familiar with writing MERGE statements in T-SQL, you'll appreciate the Upsert component. Drag the component into your Data Flow and a few clicks later you have a MERGE without the code complexities.
    • Where some native SSIS components leave you wanting more, Task Factory extends on many of these components as well as support for data sources not native to SSIS components.
    • The number of extra components that come in the Task Factory tool kit will expand your tool belt to do just about anything you need or want to accomplish in SSIS.
    Read full review

    Cons

    SolarWinds

    • Tuning advice: With all the graphs and data available, it's not always easy to determine the best thing to do. I'd like to see SentryOne provide some best practice analysis based on the historical information collected for the server being looked at.
    • They could add help tips or links to help documents, when you select a graph on the dashboard. Inexperienced users tend to put blinders on and focus on one thing when they see a high counter or something out of the ordinary. It would be very useful to include a link that provides underlying help. The link would provide an explanation of the counter in detail and offer possible explanations as to why the counter is off.
    Read full review

    SolarWinds

    • It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress.
    • Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions.
    • Occasional random failures observed with the Filter tranform.
    Read full review

    Pricing Details

    SolarWinds SQL Sentry

    Starting Price

    $0 Free

    Editions & Modules

    SolarWinds SQL Sentry editions and modules pricing
    EditionModules
    SQL Sentry1,4501
    Plan Explorer (SQL Server Query Tuning)02
    SQL Sentry for Azure SQL Database1613

    Footnotes

    1. Per year per instance (annual subscription)
    2. Free
    3. Per year per database (annual subscription)

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Request a Quote

    SolarWinds Task Factory

    Starting Price

    $0 per server

    Editions & Modules

    SolarWinds Task Factory editions and modules pricing
    EditionModules
    Task Factory1,245 (annual subscription license)1
    Task Factory Azure Data Factory1,495 (annual subscription license)2

    Footnotes

    1. per server
    2. per ADF node

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Likelihood to Renew

    SolarWinds

    Absolutely. SQL Sentry is an absolute must have for any company with a SQL Server estate. It provides a force multiplier to effectively manage SQL Server, and the feature sets are second to none. The support and expertise at SentryOne is incredible. They are very supportive of both the platform users and helping your business with the product
    Read full review

    SolarWinds

    Task Factory has become a key product for our use of doing ETL work in SSIS. Their custom SSIS components allow us to work simply on the data engineering side of things. We can ignore the lower level work needed to connect to disparate data sources. This allows us to work faster and provide more value to the business
    Read full review

    Usability

    SolarWinds

    I accept that the flexibility of the alerting comes at a price. Other than the alerting SQL Sentry's interface is intuitive. Connecting to a new SQL instance, given that all the needed ports are open in your firewalls is straight forward. Reviewing the performance and queries for an instance is available in with a right click. As you dig in new tabs are created to present the detailed data. I find the ability to filter and rollup metrics on a query very helpful in dealing with the "it's running slow". You can easily compare the metrics of run times for the same query to let the user know, it's probably data your doing a billion reads instead of the usual 100 thousand.
    Read full review

    SolarWinds

    Compared to some of the other transformations I have worked with, it really is pretty simple for the type of functionality you get
    Read full review

    Reliability and Availability

    SolarWinds

    The system is working perfectly in capturing data, but we do experience issues with SQL Timeout when viewing results in the remote clients. This may be due to the fact that our monitoring service is consuming most of the CPU, and it is the same server that is hosting the SQL Repository. We could probably fix the issue by separating the SQL instance from the monitoring service.
    Read full review

    SolarWinds

    No answers on this topic

    Performance

    SolarWinds

    In most cases the pages load very quickly. In our particular case, we need to do some movement of services to separate our monitoring service to separate infrastructure from the repository. When we first started with SQL Sentry on 5 licenses, we did not have any issues. Since we have now grown that to 25, we are experiencing some challenges. We do not believe this to be a tool problem
    Read full review

    SolarWinds

    No answers on this topic

    Support Rating

    SolarWinds

    From their infancy as a smaller company to now as a global player they have always kept focus on prioritising he customer. They know their product and the technology it supports and are easily accessible for both resolving problems with the product all the way to adding value through additional training and assisting with getting return on investment through utilisation of the many features the product provides.
    Read full review

    SolarWinds

    Overall, the best vendor we currently have on the data side of the house. No issues, issues are resolved very quickly and upgrades go without any issues.
    Read full review

    In-Person Training

    SolarWinds

    sql sentry expert came onsight to review the performance of installation and gave us a good insight to using the tool
    Read full review

    SolarWinds

    No answers on this topic

    Implementation Rating

    SolarWinds

    Was suggested that we install the process monitors on a dev or qa database server, but we found it more useful to create an IT db server and put it there (along with a few other apps that we use for monitoring).
    Read full review

    SolarWinds

    Overall it went smoothly. Had a couple of gotchas with licensing and upgrading but nothing that really stopped us.
    Read full review

    Alternatives Considered

    SolarWinds

    SQL Sentry offers more features and is customize-able to fit our business needs. It has more centralized management and support. The company's technical support is also top notch. It is also worth mentioning that SentryOne Team Blog is an excellent source. One can find lots of valuable troubleshooting skills on the blog site - very educational and informational.
    Read full review

    SolarWinds

    ZappySys is an alternative provider that we tested. However, we found the ease of use, set up and installation to be much simplier and quicker using Task Factory. ZappySys has a number of the same connectors but are more difficult to setup and the GUI is not as intuitive and simple to use.
    Read full review

    Scalability

    SolarWinds

    We are running 25 instances through a single monitoring service and it is able to keep up. We are finding that this many instances in our environment is about as many as can be handled. We will need to deploy additional monitoring services. Luckily, there is no additional licensing costs to deploy additional monitoring services. For us, it's just an additional Azure VM.
    Read full review

    SolarWinds

    No answers on this topic

    Return on Investment

    SolarWinds

    • Better customer service as it alerts me automatically to loss of service issues so I can react and either get things fixed before it impacts the customers or to let my management know as soon as possible
    • It helps me find expensive SQL so our customers get better performance and we make better use of our resources
    Read full review

    SolarWinds

    • We were able to support our developers with Task Factory features and reduce the development time by 40%.
    • Recently Task Factory has changed their pricing module and it seems to be pretty costly for our process. Our business team has started to evaluate whether this is worth it going forward.
    Read full review

    Screenshots

    Add comparison