SolarWinds SQL Sentry is designed to help data professionals optimize SQL Server database performance
in physical, virtual, and cloud environments. SQL Sentry delivers metrics to help users find and fix database performance problems
and provides scalability, boasting demonstrated success monitoring 800+ SQL
Server instances with one monitoring database. With
SQL Sentry, the user can monitor:
SQL Server
Azure SQL
Database
SQL Server
Analysis…
$0
Free
Vena
Score8.1 out of 10
Mid-Size Companies (51-1,000 employees)
Vena Solutions provides a financial process automation solution to automate Corporate Performance Management, accounting and budgeting, Regulatory & Compliance, and other finance-related processes. It is scaled for medium to large-sized organizations.
N/A
Pricing
SolarWinds SQL Sentry
Vena
Editions & Modules
Plan Explorer (SQL Server Query Tuning)
$0
Free
SQL Sentry for Azure SQL Database
$161
Per year per database (annual subscription)
SQL Sentry
1,450
Per year per instance (annual subscription)
Professional
N/A
Complete
N/A
Offerings
Pricing Offerings
SolarWinds SQL Sentry
Vena
Free Trial
Yes
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
Yes
Entry-level Setup Fee
No setup fee
Optional
Additional Details
—
The Professional Plan is the most flexible way to get started quickly and can be added onto as a company grows. The plan includes: Vena Platform, Customer Success Manager, Standard Support and Customer Portal.
Complete Plan includes everything in Professional, plus: Vena Insights, Premium Support, Sandbox Environment, and Expert Managed Services.
For a limited time, new customers who use Microsoft Dynamics 365 Business Central (Online) as their primary ERP can get a free year of Vena and 40% off implementation costs.
Vena also offers special pricing for not for profit organizations. To learn more, speak to an expert.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It is well suited for planning, budgeting, and forecasting. Using its capabilities also allows you to use it for reporting, whether it's month-end reporting or other reporting where you want to rely on data from a source that can be nicely presented and adjusted in Excel.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The Admin function of Vena, being able to set up the users in the user categories and the different groups and assigning the groups and the task bindings, is particularly easy and very helpful because as we have so many different departments and disciplines in our organization, we do need to establish pretty specific user access so this process works really well for us.
Running reports in Vena is fairly easy, and we do enjoy being able to just push a button and get some budget versus actuals.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
Have another license between power user and contributor that allows building reports that aren't ad hoc, but don't have all the admin rights of a power user.
Have a session on best in class Workforce Planning prior to implementation.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vena has become an integral part of finance and our daily process. Without it we would take longer to prepare results and decisions will be delayed. Vena has given the whole organization more visibility of results and budgets so that all departments participate more actively in managing their budgets rather than it being the sole responsibility of finance.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Vena is somehow easy to manipulate. If you want to map accounts, or change mapping. there are clear instructions and guidance. and also Vena AI is on the way, so i think we can leverage it more and let AI help us mapping and check errors. overall a very good product and easy to learn and set up.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vena is seemingly always available. They plan maintenance windows well in advance and always off hours (typically over a weekend) and communicate clearly throughout maintenance about what will be affected. Over 5 years of using the product, I can only remember one time when the platform was unavailable (I believe due to an underlying server hosting issue from their provider), and they resolved the issue and had everything up and running again within 8 hours.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The performance is dependent on how much data and calculations are involved and how complex the security settings are. A simple template or report loads in seconds. A complex template or report can take a while. If there are many users with complex security settings, that will be a factor in the load time.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
When I reach out to our support team, they are always able to fix any issues we are having in a timely manner. It is always resolved quickly which proves that customer support always helps out our support team with any issues so they can in turn help us quickly
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
This is the best way to learn and buy-in. The in person effect gives students both a hands on approach but an instruction to be there to customize assistance and understanding. In person also builds greater buy in with your future team on creators. However if your audience is better at on line learning this is another good option.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The training was structured as a group training to learn the basics of creating a data model and mapping a template. While we had nearly 10 participants, I was the only actual implementer so we probably didn't actually need the training and could have just learned the initial skills from the implementation consultant. Two years later, when we hired a new team member, they completed several modules in Vena Academy (a self paced learning course) which allowed them to get up to speed on the basics with just a bit of supplemental guidance from me as our existing admin.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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).
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The Vena consultant had great knowledge of both the Vena solution and Excel and Excel functions. He was able to help suggest ways to build our templates that met our requirements using Excel functions we had not previously considered using. And we have been able to use the Excel information he provided in other ways outside of Vena. He was very patient and flexible as we learned the Vena tool and created templates
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Previously used Synario for long-term forecasting. Ultimately moved to Vena for this to keep budgeting and forecasting together in a single solution. Vena's system is much easier to learn on the admin side since it is Excel-based so the transition was pretty simple. Previously used Jenzabar with JICS for budgeting. Vena's budget system is more user-friendly for end users and more flexible so it works better for our specific needs. Vena's reporting system is easier to use and customize.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vena solutios is a software that provides robust tools that help different departments in their statistics and we can visualize a lot of promising and visually attractive data. Vena Solutions' level of scalability is high and sustainable over time thanks to the fabulous technical support that is ready to help us at all times
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vena has helped save time by reducing the manual work involved with budgeting, reporting, and variance analysis. Instead of spending as much time organizing data and reconciling spreadsheets, I can focus more on reviewing results and making informed decisions. It has improved collaboration between teams and provided better visibility into financial performance, creating more efficient processes overall.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info