TrustRadius
https://media.trustradius.com/product-logos/XS/vW/GVXHMOPCOTRN.JPEGUse Sentry One and get to spend more time at the beach.We use SQL Sentry to manage in-house production and development databases as well as production databases of our clients. SQL Sentry allows us to effectively, efficiently manage many databases in our high volume, highly transactional system. This tool allows us to help us keep our system running smoothly and proactively fend off possible problems, greatly reducing and even eliminating the dreaded "the system seems slow today" phone call.,Determine the root cause in seconds. Determining the root cause of SQL Server issues can be a time suck in a black hole. This tool eliminates that. Historical Perspective. SQL Sentry provides an easy way to review performance intuitively over time. Indexes. The Query Plan Explorer almost makes tuning indexes fun.,UI Response Time. At times the UI is sluggish. This somewhat understandable when you realize what the tool is doing. The 2-3 UI response is not an issue though when compared with the amount of time that it saves you troubleshooting.,10,Using S1 we quickly found a bottle-neck and took server waits from 1,000s to low 100 in with about one hour of work. Using S1 we improved the UI responsiveness of our application so much that the end users actually noticed and commented.SQL Sentry ROI immediately seenSQL Sentry is used to identify issues with our custom SAAS solution for the education industry. It is used by IT to identify issues in our SQL environment and by the development team to find the root cause of SQL issues and correct and/or improve them.,Identify problem queries. Identify root causes for bottlenecks. Provide baseline and historical data for comparison.,Identifying index related issues.,9,We were able to identify queries which were causing deadlocks and, more importantly, why they were causing deadlocks and correct them. We were able to identify custom queries used with integrations which used excessive resources and fix them. We were able to identify and correct problem indexes.,We found that specific common queries were causing deadlocks which impacted both performance and usability of our application. We then worked with the development team to determine the cause and deploy a patch for our software which resulted in 70% improvement in response time from our application.,SolarWinds Database Performance Analyzer and Redgate SQL MonitorSQL Sentry adds real value for SQL Managed Service providersWe use SQL Sentry to provide an agreeable set of monitoring metrics and results which we use as part of our consulting toolset for MS SQL server. It also forms the basis of our alerting and monitoring framework that we deploy for our clients.,Easy to implement Great knowledge base Excellent support,I'd like some customisable branding for reports Having a customisable time allocation table to map alerts to an estimated, predefined chunk of time allotted to resolve the alert,10,Getting notified on SQL configuration enhancement opportunities has allowed us to more efficiently use hardware resources allocated to our SQL servers. This has greatly benefitted both us and our clients. Having historic execution plans greatly speeds up our performance tuning related to the most resource intensive queries. Our clients are finding noticeable improvements in application performance, which directly relates to optimisations based on SQL Sentry's output.,When troubleshooting performance issues on a SQL server we exhausted our normal tuning methods. We turned to SQL Sentry and found from monitoring data that this server was seeing a very high amount of Context Switches. This information pointed us to SQL server MAXDOP settings and VM CPU configuration issues. We would not have been able to find this information easily without using SQL Sentry to find the root cause.,SQL Diagnostic Manager,SQL Diagnostic ManagerSQL SentryWe currently use SQL Sentry to monitor and alert on production SQL Server systems.,Easy to see everything on one screen Awesome customer service,Alerting is confusing at first, but they are willing to help.,10,Would like to see a web based portal Like to see alerts a little easier to understand and implement,We use it all the time to find long running queries and index problems,SQL Sentry ReviewI work as a consultant and this tool is used by my clients to monitor production (dev/test in some cases) servers. Monitoring and alerting (PA and EM) is used. Fragmentation manager etc., is handled via other scripts.,Easy to set up and navigate. Provides some very important/useful metrics for performance monitoring. Custom conditions is an excellent addition to the product.,I understand that the product requires a certain level of knowledge to interpret the results but I believe tooltips on certain areas could be useful for companies that do not have this knowledge but would like to have their systems monitored and reviewed.,10,HIghlighting problem queries/procedures Areas of bottlenecks,Slow system reported, review history of that time period and pick out the top SQL,,Redgate SQL Monitor,1,1,Performance monitoring Alerting Storage forecasting,Data taken from the database to calculate "a magic number" which is an arbitrary figure to give us an easy indication as to how performance had been over the last week, day, hour etc It's like the server health but a bit more in depth analysis (at the query level) is done to calculate,PowerBI performance dashboards,Easy analysis of performance issues meaning a lot of time is saved to work on other tasks,10,No,Price Product Features Product Usability Prior Experience with the Product Existing Relationship with the Vendor,I wouldn't,Implemented in-house,No,Change management was minimal,None,10,8,No,I know they guys based in England so any questions I have guess to them. If they can't answer straight away which is unlikely then a support request is raised,Main performance dashboard is legendary. Everything you need (90% of the time) is there right in front of you.,I sometimes find the Advisory Conditions difficult to get my head around,Yes, but I don't use it,9Force MultiplierAs a Managed Service provider, SentryOne provides us with a key platform to monitor, diagnose issues and optimize performance for our customers. The platform provides the capability for services to be monitored 24/7 with in-depth, relevant information to be captured and reviewed for proactive and reactive cases, improving service delivery significantly.,Provides a fantastic review capability for historic data, collating data in a far more efficient, presentable way than you can with default tools. You know that if a customer experienced even the slightest performance dip overnight, you can review that to the finest detail later. A highly customisable monitoring system, providing rock solid information which you can drill down to the smallest detail. An outstanding Support Team, which continues to go above and beyond any expectations. The perfect SQL Server monitoring platform.,Has the potential to make the business think they can replace DBAs with this fantastic product. Windows Integrated Authentication for cross-domain monitoring (but you can monitor across domains, so this can be forgiven!).,10,Query optimisation improvements Identification of key lookups / forwarded records which once addressed provided incredible performance improvements,A business intelligence application would intermittently take two to three times its normal duration to complete its processing run, causing significant business disruption. The workload was spread across multiple SQL instances and was a black box from a code perspective. SQL Sentry identified that the application was running multiple processing runs in parallel, but this wasn't visible from a customer perspective, as they only scheduled the run once.,SpotlightThe closest thing to time travel you will experience in SQL ServerWe specifically purchased SQL Sentry Performance Advisor out of the need to resolve performance issues on one of our SQL clusters. It was difficult to troubleshoot the issues after they had occurred and SQL Sentry allowed us to review the performance over a period of time and specifically go back to when an issue occurred to troubleshoot. We now use this for the majority of our SQL estate and specifically for IT Department only.,Historical analysis of performance counters - you can go back in time or over a range to see what was happening to the server Review Top SQL and Blocking - You can see at a specific moment in time what queries are running and even review historical blocking. Baselining - Ability to set your own baselines, so you can compare what is on screen to what you expect Read only views - You can grant read only access to users, allowing us to grant support teams the ability to review the dashboards as well.,If a server is maxing out and unable to allow the service to record then you can get blackouts in the data. This is a risk of running as a service, but then you have bigger problems to deal with if that has occurred.,10,The tool has been invaluable with analysing performance issues. Being able to locate what blocking processes occurred overnight to resolve them via scheduling jobs at different times or rewriting stored procedures to run more effectively. Great for analysis and to be able to send information to vendors as to why their applications might be deadlocking or running ineffectively if it is missing indexes or statistics are not up to date,Fairly recently we had a performance issue with a SQL Server consuming 100% CPU, with the performance advisor we was able to pin point the specific queries that were a problem and advise the vendor. Which lead the vendor to make recommendations and changes to their tables and jobs. This resolved the performance issue.,Idera SQL Diagnostic Manager,System Center Operations Manager,10,Yes,Their technical sales reps are amazing, some are even Microsoft MVPs. We have had times when you might have a what if question, or even a specific SQL server question and they will always helpfully respond. One of the better vendors out there getting it right by prioritising the customers satisfaction over everything else. Always a pleasure speaking with any of the staff both on and off topic of SentryOne.Why I love SQL SentrySQL Sentry is one of my favorite tools. In a single dashboard I can see the state of most metrics I care about for daily operations and well being of the SQL instances. The most useful feature is having the ability to trace back performance issues, days and even weeks after they have occurred. You can establish a baseline and detect unusual activity in real-time.,Troubleshooting performance issues and bottlenecks. Historical review of spikes and root causes. Visualizations.,Better reports. Customizing the dashboard. Storing more historical data.,10,Faster analysis during spikes. Faster validation whether the DB is the root cause or causality during performance issues. Status monitoring on a regular basis.,Most times, the debate is usually between the DB people and the application people - who was responsible for the performance problems. E.g. was it a table being locked by SQL or was it an unresponsive application server that caused the session to hang and locks to appear. With SQL Sentry, this is easily solved.SQL Sentry - Best of BreedSQL Sentry is being used to monitor performance and support troubleshooting issues in our SQL Server infrastructure. It provides thorough and more complete information than the native tools. We use it across the main SQL Server Farm by a team of 5 DBAs,Provides a real-time view of performance. Provides comparison to historical performance baselines. Has valuable reports for the executive summary.,Difficult to limit email alerting to only actionable events. Drill down in the event calendar is difficult and can be confusing.,9,Ability to organize troubleshooting efforts of the team by providing a common view of performance. We have been able to identify major performance bottlenecks and address those more quickly. It has enabled us to spot performance degradation trends before they become user noticeable issues.,We were having a great deal of memory and CPU pressure on a critical business SQL Server and we were able to quickly trace the root cause to a poorly written SQL Server ad-hoc query. By showing the performance impact to the developer we were able to assist in having this functionality rewritten as a stored procedure and dramatically reduce resource consumption.,Redgate SQL Monitor and Idera Uptime Capacity Monitor,Oracle Application ExpressGood Tool with Exceptional Service!Monitors five servers, many with production issues. The old environment had been very neglected until a DBA was hired. I am the DBA's backup.,Query Logging, for evaluating performance. Network logging, for detecting network issues. Query plan view is VERY nice. Better than MS-SQL's native query plan visualization.,Object browser isn't the most intuitive. the "All Targets" heading is fine, but its a little weird to have your servers underneath "Default Site". Perhaps there's functionality I'm missing, but I still think the default setting should be more clear. Perhaps rename it to "Servers".,9,Problem queries are now being discussed with the development team. Network issues can easily spot the query causing the issue.,see prior answer.,TrueSight Server Automation (formerly BladeLogic Automation Suite),SQL Server Integration Services, SQL Server Data Access Components, SQL SentrySentryOne reviewWe use it to monitor our critical SQL server cluster and it is currently just used by the DBAs. It allows us to monitor in real time but also allows us to better understand why problems had happened so we can prevent them from reoccurring.,Monitors IO at multiple levels such as Storage, OS & Database level. Top SQL provides a lot detailed analysis which allows you optimise queries Alerting when setup correctly allow you to fix issues before users are aware.,Temp DB is not monitored and needs to be Improved notifications like push,8,It has helped us optimize many queries,IO waits were high and we didn't know why but using SentryOne we established IO performance on the storage was reduced which then helped us identify a problem with one of our storage controllers. Without SentryOne it would have been impossible to show the storage team evidence of the issue.Essential for any production serverPerformance Advisory allows you to quickly know what the overall performance of the servers looks like. From the dashboard you can deep dive right away to any specific area that may require attention. It contains the KPIS and data of almost all aspects of the SQL Server.,Excellent presentation of KPIs Allows you to deep dive on counters with a click of a button Lets you easily move from one time frame to another,To allow users to configure raw data retention before it is aggregated Reporting To use algorithms that alert when a relevant or critical KPI is behaving abnormally,10,It does not improve performance by itself but it shows KPIs and makes it obvious where the issues are,Correlating performance metrics is the key to resolving complex issues, and doing that without a resource that displays them in an organized manner is very hard. This tool has enabled us to identify and remove all kinds of issues, such as sources of blocking, deadlocks, storage bottlenecks, etc.,Spotlight and SolarWinds Database Performance Analyzer,SolarWinds Database Performance Analyzer, Atlassian Confluence, OpsGenieSentryOne is an Awesome ProductWe use SentryOne in our production (over 120 Instance worldwide and growing). It gives us an easy way to navigate the dashboard to quickly identify a performance problem and the ability to drill into the issue quickly and come up with a game plan to address the performance problem.,Alerting is very flexible and configurable to our needs Linking alerting into third party alerting tools via PowerShell was easy Collecting and rolling up SQL statements make it much easier to troubleshoot performance problems Drilling into PLE and what’s happening when it drops out Ease of drilling into time-frame to figure out what was the issue at that time Being able to query the SentryOne database for management reports is awesome (Deadlocks and Blocking),Navigation could be improved. It can be hard to follow if you are new to the tool Calendar of events could use some work. Display can be confusing at times,9,Reports are good but could use some improvement. For example, maybe show Friendly Name.,One time we deployed a new feature to our product, and it was causing over 88,000 plus long running queries over 2 seconds (in a one-day period) and we found the root cause to the issue in minutes. It turns out it was a missing indexing. So, to have a tool like SentryOne to help us identify this issue was great, and resolving the client’s issue within minutes of the performance problem was amazing.,Solarwinds Database Performance Analyzer for SQL Server, Redgate SQL MonitorSQL Sentry ReviewSQL Sentry is being used to monitor SQL Server performance across our entire organization, providing trending, alerting, and helping us solve the "death by a thousand cuts" types of issues that are more of a challenge to pinpoint.,SQL Agent Jobs runtime trending and alerting - out of the box alerts runtime deviations send alerts. Ad hoc trending against a previous week, day, or sampling period - pretty colors with ranges and averages to share with others. Reporting against multiple counters - this is available to compare time periods as well.,I'd like to see a "Response Time" - measuring/tracking 'Select 1' out of the box instead of having to add a custom counter. There is so much functionality in the product that we need additional training to more fully utilize it. For many DBAs this type granularity is preferred over simplicity - I'd rather have more options than too few in a monitoring product.,10,Comparing performance levels prior to an outage and sharing graphs of the same has provided risk mitigation. Finding bottlenecks during load testing. Forecasting storage usage.,During load testing we were able to quickly find the specific stored procedure that was causing the highest cumulative execution time in a specific time range using SQL Sentry.,Dell Spotlight and Foglight,Microsoft SQL Server, Redgate SQL Compare, SlackSQL Sentry is a Great ProductWe use SQL Sentry to monitor our production ERP databases. It allows easy tuning checkup, configurable emails to alert you to conditions that require attention, and offers insights into SQL that are difficult and time consuming to duplicate with SQL Management Studio.,Alerts me quickly to SQL Blocking and record locks via email, providing offending SQL and users involved. Provides an easy to monitor performance index and common issues that affect it. Alerts me to missed tasks, malfunctioning tasks, etc., via email. Really comes in handy when doing MS/Windows updates as I know exactly what was missed when the server was involved in the updates.,Don't fix too much, it works very well as delivered. Changes made for the sake of change often make a great product into a good product. Tech support is great and easy to get to, but a little more development on the help screens in the product could save you some work. I'd like to see licensing modified to allow you to monitor one production environment and one test environment. That would be tricky from your perspective, but you are a crafty lot and I'm thinking you could come up with a way to tell if I was monitoring duplicate databases or two entirely different data environments. Repeat, do not change too much, this product is great and a good value.,9,I am able to respond much quicker to complaints' cause by blocking and deadlocks and catch the server in the act rather than digging through logs for hours. I can provide my developers with code that causes issues in rapid order as well. I can scan my SQL server's overall performance from the dashboard in seconds, know if I have issues that need attention, and get a pretty good idea what I need to do to make it better. I don't find out hours later after doing MS updates that an important task got missed, SQL Sentry sends me emails during the updates and tells me what was missed.,We've had a few cases with unexpected blocking, but due to our ability to quickly narrow it to a specific time and specific SQL objects involved, we were able to determine the cause was not something developed inhouse, but a vendor customization. It was easy to duplicate with the info we had, so we were able to prove it to the vendor quickly and get them to warranty it rather than play the "he said, she said, ...." game.,Redgate SQL Monitor and Solarwinds Database Performance Analyzer for SQL Server,Microsoft SQL Server, Toad for OracleWhy Switch to SQL Sentry?SQL Sentry is being used to monitor 260 SQL instances across or enterprise. We are in the process of integrating the alerting capabilities with SCOM via SNMP. Along with alerting SS greatly increase our efficiency in resolving ongoing and past performance issues. SS also provides a central repository for reporting at the enterprise and client level. We previously used a competitors tool for 7 years but moved to SQL Sentry due to the products inability to function in our environment and more so a lack of response to the issues we were experiencing by the vendor. Our experience with SQL Sentry support has been excellent to date.,Collecting and rolling up SQL statements with the associated plan. The ability to see aggregate and individual execution of SQL statements along with the associated plan is key in rapid diagnosis of bad plans. Bad plans are the most common performance issue we see in the big data environment. The ability to drill into disk IO. Being able to easily see IO per a file can help identify issues with slow / stressed storage and or poorly distributed tables. Easily focus on time-frame. Being able to click and drag to select a time frame to analyze from a prior time frame keeps maintains the flow of troubleshooting. Alerting is inherited and highly configurable. The collection can be distributed over multiple servers allowing scaling out horizontally and fault tolerance. AD roles can be used in configuring access to the subsets of the servers being monitored. Access can be configured such that adding a user to an Active Directory role will provide access to just the servers then need to see. This works very well for our client specific operations.,The presentation of SQL server waits needs work. A large value on a throw away wait like cxpacket will change the scale such that an important wait like sos_schedular _yield is not readable. I have been told this is being addressed in the next release. Installation of the client requires sysadmin access on the repository server for the initial install. Once the install is complete sysadmin can be removed. There is a web interface but this does not have much of the functionality yet. I have not found a way to view page splits over time.,10,We are more efficient in diagnosing performance issues. Time spent on this type or diagnosis has decreased by about 75%. The tool makes it much easier to discriminate between issues due to SQL and environment issues versus solution architecture and data distribution issues.,A common experience is the SQL optimizer choosing to use a loop join on a large join. We see this even after stats update with full-scan on the associated tables. We have tried the optimizer trace flag. Process. Find the SQL statement in Top SQL Look at the historical run times/plans grid. Notice run time and color of dot. High run-time and different color, you have a bad plan. Open the plan to review operators Add hash join query option or join hints. I know this is not best practices according to MS, but the trade-offs in our OLAP environment make it the best choice.,Diagnostic Manager,Microsoft SQL Server, SQL Server Integration Services, IBM Netezza Data Warehouse Appliances, Amazon Redshift, Snowflake, Teradata Data Warehouse Appliance,10,No,It is the overall support I am impressed with. I expect the vendor to work with us and keep us informed until the issue is resolved. I want a sense that they are committed to our success. Out of the vendors we use IBM, Microsoft (Premier support), AWS, Hortonworks and SQL Sentry, SQL Sentry is the only one that has met my expectations. Based on my experience with the other vendors the majority of my support experiences have been exceptional.SentryOne Brief ReviewWe have been using SQL Sentry exclusively in our database department. Occasionally our technical leads join our analysis and troubleshooting sessions. We run screen shares in those sessions to solve application performance related issues. We have used SQL Sentry analyzing and researching long running SQL queries and deadlock issues, which have become major bottlenecks in our application development processes. The software has helped us address missing index issues and optimize query performances. In the past, we were also able to make a few important design decisions based on the analysis and statistics that were provided by SQL Sentry monitoring service. Decisions that include when and where to use application or database caching mechanism, as well as the benefit of implementing ad-hoc queries versus stored procedures. It has also helped our QA department to identify most key issues in our load tests.,Top running SQL - gives statistical information about long running queries as well the ability to customize filters. Deadlock - provides detailed graphical analysis on deadlock chains and involving parties. It is very intuitive and easy to pin point the cause of deadlocks. Baseline tuning - provides both sampling and historical trending information on SQL servers as well as detailed statistical information about resources utilization. Calendar of events - a centralized place for reviewing SQL agent jobs. Condition list - set of conditions that can be customized for business requirements.,It would be nice if the reports can be interactive like drill down, clickable content, etc. Navigation could improve and become more intuitive. Calendar of events could also improve - wish the date and time range could be specified instead of just by day or interval.,9,It has resolved majority of the deadlock issues found in our QA testing processes. It has addressed design issues in our multi-tier software development where application caching has deemed to be more efficient and appropriate. It has helped us identify missing index issues and query optimization.,One time during the application launch, we have discovered a site not responding due to heavy load on the web server. In New Relic we saw the application process that took a long time to respond but couldn't figure out the root cause. By looking into SQL sentry Top SQL tab, we immediately identified that a stored procedure that was designed to lookup information across database that had been timing out. We were able to address it immediately and prevented the site from shutting down.,Redgate SQL Monitor,Redgate SQL Compare, Redgate SQL Data Compare, New Relic APMSQL Sentry is the best performance monitoring tool on the market!!!SQL Sentry is used currently on our live platform to mange SQL performance which makes debugging issues much easier. We are looking to also implement this into our test environments so we can see the effect caused by releases at a more granular level.,Easy and simple use of the performance dashboard to see issues straight away. TOP SQL viewer to see current blocking and long running queries. HADR graph to see if there are any latency between primary and secondaries.,All changes are addressed by sentryone and in the past we have had these added into a new version.,10,Better tuning of stored procedures. Better management of indexes via the dashboard. Reducing overall CPU by investigating spikes,We were getting performance issues after a release which turned out to be indexes not covering new columns. We were able to see which procs caused the issues and the plans associated to them. We were able to quickly amend some indexes to cover the procs.,Solarwinds Database Performance Analyzer for SQL ServerBest tool to monitor SQL ServerIt's being used by a department. It addresses the quick pinpoint and resolution of any spike in resource utilization and there by avoiding impact to customer response time.,Professional graphical interface. Zoom into deep dive into issues. Ability to create a baseline and generate alerts on baseline deviation.,Check historical information on specific SQL Give overall advice post installation on tools on low hanging fruits which can be fixed right away,10,It's too early to answer this questions but we were able to nail down the cause when the CPU spiked to 90%,Right on day 1 of install. The prod CPU spiked to 90% and we were able to know the cause right away.,AppDynamics and FoglightGreat product but failed the "We're already familiar with it" testWe were testing it as a possible replacement for the current monitoring tool but unfortunately some members of the team were too stuck on their old monitoring tool.,It allowed me to drill into the memory being used by the different NUMA nodes very easily, the old tool did not. The default view shows Memory Grants Pending and that's an extremely useful item of information, better than PLE in my opinion. It's very easy to customize the alerts and create custom ones.,I would like to see a better default screen that shows the high-level status of all monitored instances in a single view. What is there isn't good enough as the color coding can be hard to see.,10,After discovering that multiple instances on a physical box with NUMA architecture weren't using all available memory, we were able to affinitize the processors to enable all instances to use all of the available memory. Performance was very much improved.,As stated earlier, it showed us that the multiple SQL Server instances on NUMA architecture weren't using all available memory so we affinitized the processors and the instances were able to use all the memory on the machine and performance was improved.,,Microsoft SQL Server, Dell Spotlight,4,1,We have it set up to page the DBAs when outages occur. We use it to find long running queries. We use it to determine which queries are hitting the SQL instances the hardest.,Faster SQL outage resolution. Faster performance resolution.,10,No,Price Product Features Product Usability Product Reputation Prior Experience with the Product Vendor Reputation,I wouldn't change a thing, this is the one I chose.,Implemented in-house,No,Change management was minimal,10SQL Sentry - Best of BreedCurrently, we use SQL Sentry to monitor database performance and debug issues as they arise. I open up the dashboard for our production environment at the start of each day. We also use it to run our complicated weekly job that spans four servers. This job calls one server and then calls back to the originating server.,The unique offering is the graphical chaining of jobs. This is especially important when the job chain spans servers. The graphs in the dashboard gives easy to follow and quick information as to the status of the database system. The timeline of the job execution has been handy when seeing how long a job has executed or when a scheduled job could cause conflicts.,I wish there was a better way to determine what queries are running at a given time. This could be a resource problem, but I found myself going to profiler a lot. Configuration of alerts is not intuitive. I want to create an alert for low disk space, but the interface was too obtuse. Navigation is also not intuitive. You have to fumble around the tree structure to get to things like the job timeline.,9,A report was added to two locations in our application. That blew out the CPU. SQL Sentry was able to identify the times when heavy usage overloaded the system. We were able to identify the report as the root cause. And quickly fix it. There was a poorly performing stored procedure that existed in the third party application we use. After an upgrade, the procedure caused our performance to drop. SQL Sentry was able to identify the queries that identified the procedure. We were able to put a patch in for the stored procedure. In the process of adding a one-time job execution, I accidentally added another run of a maintenance job. The timeline view showed my error before the end of the day, allowing me to fix my error before it became a problem.,We were seeing regular spikes in CPU on our production environment. SQL Sentry identified these are coming from a Java process. The queries looked like a report without any criteria set. By sending the graphs and the sources of the queries, our report writers found that a test report was running against our production environment.,Redgate SQL Monitor and Idera,Microsoft SQL ServerI highly recommend Performance Advisor if you manage MSSQLWe use Performance Advisor to monitor our database servers. We use this tool within the IT department to pinpoint pressure points, search for expensive queries, and for capacity planning of our databases. From a business perspective, this tool helps us to address performance problems introduced by new code and plan for new infrastructure.,Easy to setup in a Microsoft shop that depends on Active Directory Alerting cover a range of issues Detailed trace information can be retrieved and stored on demand Records blocking and deadlock events Records disk contention over time Records disk utilization over time,The disk utilization overview does not seem to accurately display volumes created using a software RAID It is difficult to determine what isolation level was used for a query. The deadlock and blocking queries tab does not record transaction isolation level either. This would help since knowing the transaction isolation level for a query would help us choose a more appropriate isolation level for the blocking transactions.,9,We are able to determine pressure points. We are always aware of our capacity. We can pinpoint production issues to a specific cause during the incident or immediately after.,We have a problem with our version of SQL Server where parameters declared as unicode (nvarchar) that are used to compare against columns that are of type Latin1 will have the database engine choose to cast the entire column to unicode instead of downgrading the parameter to a Latin1 type column. When we noticed a lot of simple single record queries using a lot of cpu and performing table scans, we were able to determine which queries needed to be rewritten.,DBTuna,WhatsUp Gold, Microsoft SQL Server, Visual Studio.NET, Windows Server, ChefSQL Sentry solves real world multi application hosting challengesOur company provides web site hosting. We use SQL Sentry Performance Advisor to monitor the production SQL Server instances supporting our hosting environment. Our hosting SQL Servers support between 10-40 different application databases. The primary driver for the workload on our application databases is the amount of traffic our hosted web sites receive. At any given time the traffic can be spiking on a specific hosted web site which will cause its corresponding database to spike and cause issues for the entire SQL Server.,Monitor many internal SQL Server metrics that can help provide early warning about potential issues. Graphing of all metrics over configurable time frames with a comparable baseline for the same time frame. The baseline feature is really helpful for understanding how metrics have changed against what is "normal". The baseline is configurable so you can use yesterday, or the same day last week, or a statistically generated baseline. The workload on our application databases varies greatly between business hours and non-business hours so the baseline feature comparing to same day of the week from the previous week is helpful. Top consuming queries - SQL Sentry captures the top consuming queries. This helps to identify which database and which function within a database is consuming the most CPU or Disk i/o. Query Plans - when SQL Sentry captures a top consuming query - it captures its associated Query Plan. This is very helpful for figuring out why a query is consuming so many resources.,SQL Sentry is a stand alone solution. There is no direct correlation between SQL Sentry events and application exception events or web server events. All correlation has to be done manually. This isn't really a problem directly with SQL Sentry - but is more the nature of using a stand alone solution like SQL Sentry. Using SQL Sentry for reporting can be slow. SQL Sentry is gathering a lot of data. All of that data is written into a SQL database. Reporting pulls from the same SQL Database. If pulling data for a long time range the resulting report can take a long time to load. Data Aggregation over time - When you run a report on a specific time range you have very detailed data available. When you run a report over a longer time range the data is aggregated together and specific anomalies get watered down. For example if you run a report over a 10 minute period you will see data at ~1 sec granularity. This makes it really clear where there was a spike in activity. If you run a report over a 24 hour period you will only see general trends. The data is at about 5 min granularity. So there may be a time period where you see a slight rise. You have to zoom in on that specific time frame to see more granular data. As a pro - SQL Sentry makes the process of zooming in and out on different time ranges very easy.,8,More junior members of my team are able to troubleshoot SQL performance issues without needing to engage our senior DBA We can very quickly identify which database on a server is causing us issues. This is huge since we run a multi-tenant environment. Knowing which tenant is the culprit greatly helps cut down time to resolution.,We had an application database that would occasionally spike to 100% CPU. SQL Sentry helped us identify which database was consuming the CPU. That was pretty straightfoward. What was not straightforward was figuring out why the database was consuming 100% CPU. Every indicator we could see on the surface was that the workload had remained consistent. The volume of requests and type of requests going to the web application were consistent. The volume of SQL transactions was consistent. Where SQL Sentry provided it's worth was in Top Queries. It showed us that one specific query was consuming all of the CPU. When we looked at the execution plan that was captured by SQL Sentry we could see that a sub-optimal plan had been cached. We were then able to flush the cached plan and a new more optimal plan was cached. This returned the database CPU consumption to normal. We then worked through updating the SPROC so that a sub-optimal plan would not be cached. SQL Sentry Top Queries and execution plan capture were critical to handling this incident.,,Pingdom, PagerDuty, Power Admin PA Server MonitorSQL Sentry, the first line of defence for your serverSQL Sentry was purchased to monitor our new Business Intelligence Infrastructure. The tool allows us to see at a glance if we have any performance issues; we also utilise the alerting feature heavily to make sure that even when we are not in the office or connected we can still see how the server is performing.,Alerting features are a must, it takes a little while to tune them to your system but once you have them, they will save you and your team countless hours of recovery / server maintenance as you can stop the issue before it even becomes one. Performance Manager is great to understand not only how your server is performing now but also any time in the past. We utilise this to drill into any unusual activity with ease due to the UI being so intuitive and self explanatory. Again a massive time saver The cloud based reporting is very useful for a quick health check when you are not near your laptop.,The event manager can really cluttered when using it on a business intelligence server with jobs running throughout the day. It would be great to see this in a different visualisation that could really help you spot the key hot spots, possibly create an impact metric that displays the jobs size depending on how much resource the job took to complete.,9,we are spotting issues before they become a significant risk to the server we have a better understanding of the server and how it performs on a daily and intraday basis,We had a long running query that locked a lot of the schema out of hours, with SQL Sentry not only could I identify what was blocking everything else but also view the specific part of the code and it's execution plan, look at what else was running at the time and then tune the SQL as well as reschedule some activity.,Redgate SQL Monitor,Microsoft SQL Server, Microsoft Visual Studio Team SystemSQLSentry Performance Advisor helped me manage my SQL Server environmentSQL Sentry Performance Advisor has been used as a primary monitoring tool for our production environment, it has helped us a lot with troubleshooting bottlenecks, finding performance problems, resolving blocking etc. We're using this tool across the whole organization and monitoring around fifteen large production SQL Servers.,I can see global view of all my monitored servers on single screen with CPU, Memory, Disk & network usages based on last sample or even historical for upto 3 days. Also if there is an area of concerns Performance Advisor will highlighted that server with red or orange depending upon the condition or level of concerns. Blocking and deadlock situations are clearly visible which gives insight to resolve conflicts. Disk Activity section provides clear visibility of each and every data files (.MDF, .LDF & .NDF) with the level of activity (Read & Write operations) which is very helpful for us for our OLTP environment to monitor and keep a watch on response from storage system. Alert system is good.,I believe SQL Sentry has good alert mechanism but still I see a room for improvement, for example recently we tried to change subject line of specific type of alerts (for example server offline, or high CPU utilization etc.) to make it more meaningful for our organization and we had hard time doing this. Reports need some improvement, reports are good but I believe few summary report need to be added which reflects overall performance of the environment. For example downtime report is available which serves the purpose of availability but having similar reports to reflect high level performance reporting would be helpful. In the global view under the disk section ms/IO shows the values based on the sample and changes the color from depending upon threshold which is a good feature. Also, upon right click it allows to generate quick report which again shows time & value for ms/IO. So, it would be a great feature if SQL Sentry can add a functionality to show which particular LUN(s) is responding slowly.,9,It helped us identifying most resource intensive queries and allowed to track average execution time of some queries which is improved few my adding some indexes and few my changing query within our application. In past we had issue with one of our disk which was housing tempDB file, when we started using Performance Advisor, we were able to identify slow response of that disk and was able to work with our storage team/vendor to fix that problem. Disk activity sections shows the "Total VLFs" which helped me reducing the VLFs out of LDFs with high VLFs. Obviously there are scripts to get number of VLFs but being available on tool itself is really handy.,We had performance issue with one of the drive which was housing files for tempDB of one of our critical SQL Server and we always had performance issues with that server. After the implementation of SQL Sentry Performance Advisor, we were able to identify that problematic disk and resolve that issue. This is one of the best example I would like to share here.,Redgate SQL Monitor,SolarWinds Network Performance Monitor
Windows, Linux, Amazon RDS and EC2, Azure SQL DB Managed Instance
SQL Sentry
134 Ratings
Score 9.5 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

SQL Sentry Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
SQL Sentry
134 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 9.5 out of 101
Show Filters 
Hide Filters 
Filter 134 vetted SQL Sentry reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 81)

  Vendors can't alter or remove reviews. Here's why.
Steve Lomicka profile photo
June 01, 2019

SQL Sentry Review: "Use Sentry One and get to spend more time at the beach."

Score 10 out of 10
Vetted Review
Verified User
Review Source
We use SQL Sentry to manage in-house production and development databases as well as production databases of our clients. SQL Sentry allows us to effectively, efficiently manage many databases in our high volume, highly transactional system. This tool allows us to help us keep our system running smoothly and proactively fend off possible problems, greatly reducing and even eliminating the dreaded "the system seems slow today" phone call.
  • Determine the root cause in seconds. Determining the root cause of SQL Server issues can be a time suck in a black hole. This tool eliminates that.
  • Historical Perspective. SQL Sentry provides an easy way to review performance intuitively over time.
  • Indexes. The Query Plan Explorer almost makes tuning indexes fun.
  • UI Response Time. At times the UI is sluggish. This somewhat understandable when you realize what the tool is doing. The 2-3 UI response is not an issue though when compared with the amount of time that it saves you troubleshooting.
There are a lot of choices in this area, a few leaders. The entire process from pre-sales, to sales, training and finally using S1 daily has been smooth. The combination of all aspects of the company and product leads to a "you can't go wrong with S1" recommendation.
Read Steve Lomicka's full review
Jim Rothe profile photo
April 24, 2019

User Review: "SQL Sentry ROI immediately seen"

Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry is used to identify issues with our custom SAAS solution for the education industry. It is used by IT to identify issues in our SQL environment and by the development team to find the root cause of SQL issues and correct and/or improve them.
  • Identify problem queries.
  • Identify root causes for bottlenecks.
  • Provide baseline and historical data for comparison.
  • Identifying index related issues.
I cannot think of any scenario where it would not be useful. It is very helpful in identifying where we can improve our code to improve performance and reliability.
We found that specific common queries were causing deadlocks which impacted both performance and usability of our application. We then worked with the development team to determine the cause and deploy a patch for our software which resulted in 70% improvement in response time from our application.
Read Jim Rothe's full review
Adrian Sullivan profile photo
February 26, 2019

Review: "SQL Sentry adds real value for SQL Managed Service providers"

Score 10 out of 10
Vetted Review
Reseller
Review Source
We use SQL Sentry to provide an agreeable set of monitoring metrics and results which we use as part of our consulting toolset for MS SQL server.
It also forms the basis of our alerting and monitoring framework that we deploy for our clients.
  • Easy to implement
  • Great knowledge base
  • Excellent support
  • I'd like some customisable branding for reports
  • Having a customisable time allocation table to map alerts to an estimated, predefined chunk of time allotted to resolve the alert
SQL Sentry is amazing at getting information relating to the state of SQL servers. Alerts and issues are easy to consume as an action list.
When troubleshooting performance issues on a SQL server we exhausted our normal tuning methods. We turned to SQL Sentry and found from monitoring data that this server was seeing a very high amount of Context Switches.
This information pointed us to SQL server MAXDOP settings and VM CPU configuration issues.
We would not have been able to find this information easily without using SQL Sentry to find the root cause.
Read Adrian Sullivan's full review
Michael Abernathy profile photo
April 26, 2019

User Review: "SQL Sentry"

Score 10 out of 10
Vetted Review
Verified User
Review Source
We currently use SQL Sentry to monitor and alert on production SQL Server systems.
  • Easy to see everything on one screen
  • Awesome customer service
  • Alerting is confusing at first, but they are willing to help.
SQL Sentry is well suited for a SQL Server shop. We also use DB2 and the DB2 guys are very jealous over the SQL Server monitoring tools.
We use it all the time to find long running queries and index problems
Read Michael Abernathy's full review
Chris Taylor profile photo
March 15, 2019

"SQL Sentry Review"

Score 10 out of 10
Vetted Review
Reseller
Review Source
I work as a consultant and this tool is used by my clients to monitor production (dev/test in some cases) servers. Monitoring and alerting (PA and EM) is used. Fragmentation manager etc., is handled via other scripts.
  • Easy to set up and navigate.
  • Provides some very important/useful metrics for performance monitoring.
  • Custom conditions is an excellent addition to the product.
  • I understand that the product requires a certain level of knowledge to interpret the results but I believe tooltips on certain areas could be useful for companies that do not have this knowledge but would like to have their systems monitored and reviewed.
I know virtualisation monitoring is available with future work in the pipeline but at present this is an area that I would like to see improved.
Slow system reported, review history of that time period and pick out the top SQL
Read Chris Taylor's full review
No photo available
April 17, 2019

SQL Sentry Review: "Force Multiplier"

Score 10 out of 10
Vetted Review
Verified User
Review Source
As a Managed Service provider, SentryOne provides us with a key platform to monitor, diagnose issues and optimize performance for our customers. The platform provides the capability for services to be monitored 24/7 with in-depth, relevant information to be captured and reviewed for proactive and reactive cases, improving service delivery significantly.
  • Provides a fantastic review capability for historic data, collating data in a far more efficient, presentable way than you can with default tools. You know that if a customer experienced even the slightest performance dip overnight, you can review that to the finest detail later.
  • A highly customisable monitoring system, providing rock solid information which you can drill down to the smallest detail.
  • An outstanding Support Team, which continues to go above and beyond any expectations.
  • The perfect SQL Server monitoring platform.
  • Has the potential to make the business think they can replace DBAs with this fantastic product.
  • Windows Integrated Authentication for cross-domain monitoring (but you can monitor across domains, so this can be forgiven!).
A customer experiences a slow Analysis Services cube processing overnight from their Data Warehouse and wants to understand why this issue has occurred. SentryOne provides you the capability to see exactly what happened, with just as much detail as if you were sitting on the servers at 3:00am monitoring it directly. This applies for SQL Server, Windows, Azure, APS. Once you have experienced the product, you will realize you must have it.
A business intelligence application would intermittently take two to three times its normal duration to complete its processing run, causing significant business disruption. The workload was spread across multiple SQL instances and was a black box from a code perspective. SQL Sentry identified that the application was running multiple processing runs in parallel, but this wasn't visible from a customer perspective, as they only scheduled the run once.
Read this authenticated review
No photo available
March 12, 2019

SQL Sentry Review: "The closest thing to time travel you will experience in SQL Server"

Score 10 out of 10
Vetted Review
Verified User
Review Source
We specifically purchased SQL Sentry Performance Advisor out of the need to resolve performance issues on one of our SQL clusters. It was difficult to troubleshoot the issues after they had occurred and SQL Sentry allowed us to review the performance over a period of time and specifically go back to when an issue occurred to troubleshoot. We now use this for the majority of our SQL estate and specifically for IT Department only.
  • Historical analysis of performance counters - you can go back in time or over a range to see what was happening to the server
  • Review Top SQL and Blocking - You can see at a specific moment in time what queries are running and even review historical blocking.
  • Baselining - Ability to set your own baselines, so you can compare what is on screen to what you expect
  • Read only views - You can grant read only access to users, allowing us to grant support teams the ability to review the dashboards as well.
  • If a server is maxing out and unable to allow the service to record then you can get blackouts in the data. This is a risk of running as a service, but then you have bigger problems to deal with if that has occurred.
SQL Sentry can be utilised for both performance monitoring and alerting. It is good if you need to analyse performance issues whether in production or in development. Easily can export stats to send to vendors where applications are not performing well. And can setup alert thresholds that can send emails to support teams or write out to SCOM or the event log.
Fairly recently we had a performance issue with a SQL Server consuming 100% CPU, with the performance advisor we was able to pin point the specific queries that were a problem and advise the vendor. Which lead the vendor to make recommendations and changes to their tables and jobs. This resolved the performance issue.
Read this authenticated review
No photo available
May 08, 2019

User Review: "Why I love SQL Sentry"

Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry is one of my favorite tools. In a single dashboard I can see the state of most metrics I care about for daily operations and well being of the SQL instances. The most useful feature is having the ability to trace back performance issues, days and even weeks after they have occurred. You can establish a baseline and detect unusual activity in real-time.
  • Troubleshooting performance issues and bottlenecks.
  • Historical review of spikes and root causes.
  • Visualizations.
  • Better reports.
  • Customizing the dashboard.
  • Storing more historical data.
It's best for real-time and historical analysis of what is going on in your systems. However, since it's limited to 5000 sessions in some cases it won't fit certain systems.
Most times, the debate is usually between the DB people and the application people - who was responsible for the performance problems. E.g. was it a table being locked by SQL or was it an unresponsive application server that caused the session to hang and locks to appear. With SQL Sentry, this is easily solved.
Read this authenticated review
No photo available
May 07, 2019

User Review: "SQL Sentry - Best of Breed"

Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry is being used to monitor performance and support troubleshooting issues in our SQL Server infrastructure. It provides thorough and more complete information than the native tools. We use it across the main SQL Server Farm by a team of 5 DBAs
  • Provides a real-time view of performance.
  • Provides comparison to historical performance baselines.
  • Has valuable reports for the executive summary.
  • Difficult to limit email alerting to only actionable events.
  • Drill down in the event calendar is difficult and can be confusing.
This product has value for medium to large SQL Server infrastructures. Smaller instantiations of less than 10 instances will derive value but not as much as those organizations with 10 or more servers to monitor. SQL Sentry's newer product (SQL Sentry Essentials) is the appropriate choice for these cases.
We were having a great deal of memory and CPU pressure on a critical business SQL Server and we were able to quickly trace the root cause to a poorly written SQL Server ad-hoc query. By showing the performance impact to the developer we were able to assist in having this functionality rewritten as a stored procedure and dramatically reduce resource consumption.
Read this authenticated review
No photo available
April 24, 2019

SQL Sentry Review: "Good Tool with Exceptional Service!"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Monitors five servers, many with production issues. The old environment had been very neglected until a DBA was hired. I am the DBA's backup.
  • Query Logging, for evaluating performance.
  • Network logging, for detecting network issues.
  • Query plan view is VERY nice. Better than MS-SQL's native query plan visualization.
  • Object browser isn't the most intuitive. the "All Targets" heading is fine, but its a little weird to have your servers underneath "Default Site". Perhaps there's functionality I'm missing, but I still think the default setting should be more clear. Perhaps rename it to "Servers".
Haven't nearly explored all that is possible with SQL Sentry, however it was essential to diagnosing an issue we had recently. A very fast query was running thousands of times, vs. just occasionally as in the prior release. This would have been near impossible to find without SQL Sentry logging this query. Also, the network activity dashboard was the first indication there was a problem, which was our first indication of the issue.
Read this authenticated review
No photo available
April 30, 2019

SQL Sentry: "SentryOne review"

Score 8 out of 10
Vetted Review
Verified User
Review Source
We use it to monitor our critical SQL server cluster and it is currently just used by the DBAs. It allows us to monitor in real time but also allows us to better understand why problems had happened so we can prevent them from reoccurring.
  • Monitors IO at multiple levels such as Storage, OS & Database level.
  • Top SQL provides a lot detailed analysis which allows you optimise queries
  • Alerting when setup correctly allow you to fix issues before users are aware.
  • Temp DB is not monitored and needs to be
  • Improved notifications like push
IO waits were high and we didn't know why but using SentryOne we established IO performance on the storage was reduced which then helped us identify a problem with one of our storage controllers. Without SentryOne it would have been impossible to show the storage team evidence of the issue.
Read this authenticated review
No photo available
April 15, 2019

SQL Sentry Review: "Essential for any production server"

Score 10 out of 10
Vetted Review
Verified User
Review Source
Performance Advisory allows you to quickly know what the overall performance of the servers looks like. From the dashboard you can deep dive right away to any specific area that may require attention. It contains the KPIS and data of almost all aspects of the SQL Server.
  • Excellent presentation of KPIs
  • Allows you to deep dive on counters with a click of a button
  • Lets you easily move from one time frame to another
  • To allow users to configure raw data retention before it is aggregated
  • Reporting
  • To use algorithms that alert when a relevant or critical KPI is behaving abnormally
I think it is well suited for all scenarios where an SQL Server is involved. Given the costs perhaps I wouldn't spend money paying for licensing on Development environments.
Correlating performance metrics is the key to resolving complex issues, and doing that without a resource that displays them in an organized manner is very hard. This tool has enabled us to identify and remove all kinds of issues, such as sources of blocking, deadlocks, storage bottlenecks, etc.
Read this authenticated review
Louis Fritz profile photo
October 09, 2018

SQL Sentry Review: "SentryOne is an Awesome Product"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use SentryOne in our production (over 120 Instance worldwide and growing). It gives us an easy way to navigate the dashboard to quickly identify a performance problem and the ability to drill into the issue quickly and come up with a game plan to address the performance problem.
  • Alerting is very flexible and configurable to our needs
  • Linking alerting into third party alerting tools via PowerShell was easy
  • Collecting and rolling up SQL statements make it much easier to troubleshoot performance problems
  • Drilling into PLE and what’s happening when it drops out
  • Ease of drilling into time-frame to figure out what was the issue at that time
  • Being able to query the SentryOne database for management reports is awesome (Deadlocks and Blocking)
  • Navigation could be improved. It can be hard to follow if you are new to the tool
  • Calendar of events could use some work. Display can be confusing at times
It’s great for a DBA to have a tool like SentryOne. To be able to troubleshoot our production environment and come up with a root cause to a performance issue in very little time is awesome. Being able to drill into an instance and see what happened yesterday when a user walks up to our desk and tells us the instance was slow yesterday and they want to know what was going on.
One time we deployed a new feature to our product, and it was causing over 88,000 plus long running queries over 2 seconds (in a one-day period) and we found the root cause to the issue in minutes. It turns out it was a missing indexing. So, to have a tool like SentryOne to help us identify this issue was great, and resolving the client’s issue within minutes of the performance problem was amazing.
Read Louis Fritz's full review
Lars Rasmussen profile photo
November 23, 2018

"SQL Sentry Review"

Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry is being used to monitor SQL Server performance across our entire organization, providing trending, alerting, and helping us solve the "death by a thousand cuts" types of issues that are more of a challenge to pinpoint.
  • SQL Agent Jobs runtime trending and alerting - out of the box alerts runtime deviations send alerts.
  • Ad hoc trending against a previous week, day, or sampling period - pretty colors with ranges and averages to share with others.
  • Reporting against multiple counters - this is available to compare time periods as well.
  • I'd like to see a "Response Time" - measuring/tracking 'Select 1' out of the box instead of having to add a custom counter.
  • There is so much functionality in the product that we need additional training to more fully utilize it. For many DBAs this type granularity is preferred over simplicity - I'd rather have more options than too few in a monitoring product.
SQL Sentry is more suited to managing SQL Server performance issues in an enterprise environment. If you are a small shop it may not be the best fit due to cost.
During load testing we were able to quickly find the specific stored procedure that was causing the highest cumulative execution time in a specific time range using SQL Sentry.
Read Lars Rasmussen's full review
Dennis Squires profile photo
May 21, 2018

User Review: "SQL Sentry is a Great Product"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use SQL Sentry to monitor our production ERP databases. It allows easy tuning checkup, configurable emails to alert you to conditions that require attention, and offers insights into SQL that are difficult and time consuming to duplicate with SQL Management Studio.
  • Alerts me quickly to SQL Blocking and record locks via email, providing offending SQL and users involved.
  • Provides an easy to monitor performance index and common issues that affect it.
  • Alerts me to missed tasks, malfunctioning tasks, etc., via email. Really comes in handy when doing MS/Windows updates as I know exactly what was missed when the server was involved in the updates.
  • Don't fix too much, it works very well as delivered. Changes made for the sake of change often make a great product into a good product.
  • Tech support is great and easy to get to, but a little more development on the help screens in the product could save you some work.
  • I'd like to see licensing modified to allow you to monitor one production environment and one test environment. That would be tricky from your perspective, but you are a crafty lot and I'm thinking you could come up with a way to tell if I was monitoring duplicate databases or two entirely different data environments.
  • Repeat, do not change too much, this product is great and a good value.
Unless you really don't care about performance and reliability, I can't imagine a SQL environment which would not benefit from SQL Sentry.
We've had a few cases with unexpected blocking, but due to our ability to quickly narrow it to a specific time and specific SQL objects involved, we were able to determine the cause was not something developed inhouse, but a vendor customization. It was easy to duplicate with the info we had, so we were able to prove it to the vendor quickly and get them to warranty it rather than play the "he said, she said, ...." game.
Read Dennis Squires's full review
Mark Lessard profile photo
January 12, 2018

User Review: "Why Switch to SQL Sentry?"

Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry is being used to monitor 260 SQL instances across or enterprise. We are in the process of integrating the alerting capabilities with SCOM via SNMP. Along with alerting SS greatly increase our efficiency in resolving ongoing and past performance issues. SS also provides a central repository for reporting at the enterprise and client level. We previously used a competitors tool for 7 years but moved to SQL Sentry due to the products inability to function in our environment and more so a lack of response to the issues we were experiencing by the vendor. Our experience with SQL Sentry support has been excellent to date.
  • Collecting and rolling up SQL statements with the associated plan. The ability to see aggregate and individual execution of SQL statements along with the associated plan is key in rapid diagnosis of bad plans. Bad plans are the most common performance issue we see in the big data environment.
  • The ability to drill into disk IO. Being able to easily see IO per a file can help identify issues with slow / stressed storage and or poorly distributed tables.
  • Easily focus on time-frame. Being able to click and drag to select a time frame to analyze from a prior time frame keeps maintains the flow of troubleshooting.
  • Alerting is inherited and highly configurable.
  • The collection can be distributed over multiple servers allowing scaling out horizontally and fault tolerance.
  • AD roles can be used in configuring access to the subsets of the servers being monitored. Access can be configured such that adding a user to an Active Directory role will provide access to just the servers then need to see. This works very well for our client specific operations.
  • The presentation of SQL server waits needs work. A large value on a throw away wait like cxpacket will change the scale such that an important wait like sos_schedular _yield is not readable. I have been told this is being addressed in the next release.
  • Installation of the client requires sysadmin access on the repository server for the initial install. Once the install is complete sysadmin can be removed.
  • There is a web interface but this does not have much of the functionality yet.
  • I have not found a way to view page splits over time.
I only see one scenario for this type of tool. I want all tools in this category to collect OS and SQL performance metrics over a time frame and present and or alert on them in a way that allows me to diagnose availability and performance issues on the servers. I need this information in real time and historically. I need to be able to report on this information at the micro and macro level. I need a tool that just works and a company that stands behind there tool. SQL Sentry meets these needs.

The only scenario I see were SQL Sentry would not work is were purchase cost of the product is weighted very heavily as opposed to all other factors.
A common experience is the SQL optimizer choosing to use a loop join on a large join. We see this even after stats update with full-scan on the associated tables. We have tried the optimizer trace flag.

Process.
Find the SQL statement in Top SQL
Look at the historical run times/plans grid. Notice run time and color of dot. High run-time and different color, you have a bad plan.
Open the plan to review operators
Add hash join query option or join hints. I know this is not best practices according to MS, but the trade-offs in our OLAP environment make it the best choice.


Read Mark Lessard's full review
Jun Tang profile photo
November 28, 2017

SQL Sentry: "SentryOne Brief Review"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We have been using SQL Sentry exclusively in our database department. Occasionally our technical leads join our analysis and troubleshooting sessions. We run screen shares in those sessions to solve application performance related issues. We have used SQL Sentry analyzing and researching long running SQL queries and deadlock issues, which have become major bottlenecks in our application development processes. The software has helped us address missing index issues and optimize query performances. In the past, we were also able to make a few important design decisions based on the analysis and statistics that were provided by SQL Sentry monitoring service. Decisions that include when and where to use application or database caching mechanism, as well as the benefit of implementing ad-hoc queries versus stored procedures. It has also helped our QA department to identify most key issues in our load tests.
  • Top running SQL - gives statistical information about long running queries as well the ability to customize filters.
  • Deadlock - provides detailed graphical analysis on deadlock chains and involving parties. It is very intuitive and easy to pin point the cause of deadlocks.
  • Baseline tuning - provides both sampling and historical trending information on SQL servers as well as detailed statistical information about resources utilization.
  • Calendar of events - a centralized place for reviewing SQL agent jobs.
  • Condition list - set of conditions that can be customized for business requirements.
  • It would be nice if the reports can be interactive like drill down, clickable content, etc.
  • Navigation could improve and become more intuitive.
  • Calendar of events could also improve - wish the date and time range could be specified instead of just by day or interval.
SQL Sentry is well suited in a professional environment where experienced DBAs are available. It requires some learning curve to understand all the counters and measures before one can started troubleshooting SQL server issues. This product may not benefit companies that have only a few servers to manage. Larger companies should benefit more as the product is a huge time saver when DBAs have to manage a cluster of SQL servers.
One time during the application launch, we have discovered a site not responding due to heavy load on the web server. In New Relic we saw the application process that took a long time to respond but couldn't figure out the root cause. By looking into SQL sentry Top SQL tab, we immediately identified that a stored procedure that was designed to lookup information across database that had been timing out. We were able to address it immediately and prevented the site from shutting down.
Read Jun Tang's full review
Nick Buckley profile photo
November 14, 2017

Review: "SQL Sentry is the best performance monitoring tool on the market!!!"

Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry is used currently on our live platform to mange SQL performance which makes debugging issues much easier. We are looking to also implement this into our test environments so we can see the effect caused by releases at a more granular level.
  • Easy and simple use of the performance dashboard to see issues straight away.
  • TOP SQL viewer to see current blocking and long running queries.
  • HADR graph to see if there are any latency between primary and secondaries.
  • All changes are addressed by sentryone and in the past we have had these added into a new version.
When we are getting techincal live issues on the website SQL Sentry is the first tool I use and the majority of times its the only thing I need to look at.
We were getting performance issues after a release which turned out to be indexes not covering new columns. We were able to see which procs caused the issues and the plans associated to them. We were able to quickly amend some indexes to cover the procs.
Read Nick Buckley's full review
No photo available
August 28, 2017

SQL Sentry Review: "Best tool to monitor SQL Server"

Score 10 out of 10
Vetted Review
Verified User
Review Source
It's being used by a department. It addresses the quick pinpoint and resolution of any spike in resource utilization and there by avoiding impact to customer response time.
  • Professional graphical interface.
  • Zoom into deep dive into issues.
  • Ability to create a baseline and generate alerts on baseline deviation.
  • Check historical information on specific SQL
  • Give overall advice post installation on tools on low hanging fruits which can be fixed right away
Across all the tools available in the market for SQL server, I would SentryOne is head of the competitors.
Right on day 1 of install. The prod CPU spiked to 90% and we were able to know the cause right away.
Read this authenticated review
No photo available
November 28, 2017

SQL Sentry Review: "Great product but failed the "We're already familiar with it" test"

Score 10 out of 10
Vetted Review
Verified User
Review Source
We were testing it as a possible replacement for the current monitoring tool but unfortunately some members of the team were too stuck on their old monitoring tool.
  • It allowed me to drill into the memory being used by the different NUMA nodes very easily, the old tool did not.
  • The default view shows Memory Grants Pending and that's an extremely useful item of information, better than PLE in my opinion.
  • It's very easy to customize the alerts and create custom ones.
  • I would like to see a better default screen that shows the high-level status of all monitored instances in a single view. What is there isn't good enough as the color coding can be hard to see.
It doesn't work well in highly compartmentalized environments, as in, firewall issues can be hard to work through.
As stated earlier, it showed us that the multiple SQL Server instances on NUMA architecture weren't using all available memory so we affinitized the processors and the instances were able to use all the memory on the machine and performance was improved.
Read this authenticated review
Derek Knutsen profile photo
January 13, 2017

User Review: "SQL Sentry - Best of Breed"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Currently, we use SQL Sentry to monitor database performance and debug issues as they arise. I open up the dashboard for our production environment at the start of each day. We also use it to run our complicated weekly job that spans four servers. This job calls one server and then calls back to the originating server.
  • The unique offering is the graphical chaining of jobs. This is especially important when the job chain spans servers.
  • The graphs in the dashboard gives easy to follow and quick information as to the status of the database system.
  • The timeline of the job execution has been handy when seeing how long a job has executed or when a scheduled job could cause conflicts.
  • I wish there was a better way to determine what queries are running at a given time. This could be a resource problem, but I found myself going to profiler a lot.
  • Configuration of alerts is not intuitive. I want to create an alert for low disk space, but the interface was too obtuse.
  • Navigation is also not intuitive. You have to fumble around the tree structure to get to things like the job timeline.
SQL Sentry is good for overall monitoring and job configuration. There are capabilities for deep-dive troubleshooting. However, it is highly recommended to get training. Be prepared for a steep learning curve on how to get the system configured the way you want it. But, it is worth it. Do not expect this to be an all in one solution. This will not take care of backups.
We were seeing regular spikes in CPU on our production environment. SQL Sentry identified these are coming from a Java process. The queries looked like a report without any criteria set. By sending the graphs and the sources of the queries, our report writers found that a test report was running against our production environment.
Read Derek Knutsen's full review
Hiram Amador profile photo
May 13, 2016

SQL Sentry Review: "I highly recommend Performance Advisor if you manage MSSQL"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Performance Advisor to monitor our database servers. We use this tool within the IT department to pinpoint pressure points, search for expensive queries, and for capacity planning of our databases. From a business perspective, this tool helps us to address performance problems introduced by new code and plan for new infrastructure.
  • Easy to setup in a Microsoft shop that depends on Active Directory
  • Alerting cover a range of issues
  • Detailed trace information can be retrieved and stored on demand
  • Records blocking and deadlock events
  • Records disk contention over time
  • Records disk utilization over time
  • The disk utilization overview does not seem to accurately display volumes created using a software RAID
  • It is difficult to determine what isolation level was used for a query.
  • The deadlock and blocking queries tab does not record transaction isolation level either. This would help since knowing the transaction isolation level for a query would help us choose a more appropriate isolation level for the blocking transactions.
Performance Advisor is specifically designed for MSSQL database servers located within a Microsoft domain. I can not vouch for the product in monitoring Oracle databases or environments where a non-Microsoft domain is used, or no domain is used at all.
We have a problem with our version of SQL Server where parameters declared as unicode (nvarchar) that are used to compare against columns that are of type Latin1 will have the database engine choose to cast the entire column to unicode instead of downgrading the parameter to a Latin1 type column. When we noticed a lot of simple single record queries using a lot of cpu and performing table scans, we were able to determine which queries needed to be rewritten.
Read Hiram Amador's full review
Zachary Peer profile photo
April 29, 2016

Review: "SQL Sentry solves real world multi application hosting challenges"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Our company provides web site hosting. We use SQL Sentry Performance Advisor to monitor the production SQL Server instances supporting our hosting environment. Our hosting SQL Servers support between 10-40 different application databases. The primary driver for the workload on our application databases is the amount of traffic our hosted web sites receive. At any given time the traffic can be spiking on a specific hosted web site which will cause its corresponding database to spike and cause issues for the entire SQL Server.
  • Monitor many internal SQL Server metrics that can help provide early warning about potential issues.
  • Graphing of all metrics over configurable time frames with a comparable baseline for the same time frame. The baseline feature is really helpful for understanding how metrics have changed against what is "normal". The baseline is configurable so you can use yesterday, or the same day last week, or a statistically generated baseline. The workload on our application databases varies greatly between business hours and non-business hours so the baseline feature comparing to same day of the week from the previous week is helpful.
  • Top consuming queries - SQL Sentry captures the top consuming queries. This helps to identify which database and which function within a database is consuming the most CPU or Disk i/o.
  • Query Plans - when SQL Sentry captures a top consuming query - it captures its associated Query Plan. This is very helpful for figuring out why a query is consuming so many resources.
  • SQL Sentry is a stand alone solution. There is no direct correlation between SQL Sentry events and application exception events or web server events. All correlation has to be done manually. This isn't really a problem directly with SQL Sentry - but is more the nature of using a stand alone solution like SQL Sentry.
  • Using SQL Sentry for reporting can be slow. SQL Sentry is gathering a lot of data. All of that data is written into a SQL database. Reporting pulls from the same SQL Database. If pulling data for a long time range the resulting report can take a long time to load.
  • Data Aggregation over time - When you run a report on a specific time range you have very detailed data available. When you run a report over a longer time range the data is aggregated together and specific anomalies get watered down. For example if you run a report over a 10 minute period you will see data at ~1 sec granularity. This makes it really clear where there was a spike in activity. If you run a report over a 24 hour period you will only see general trends. The data is at about 5 min granularity. So there may be a time period where you see a slight rise. You have to zoom in on that specific time frame to see more granular data. As a pro - SQL Sentry makes the process of zooming in and out on different time ranges very easy.
SQL Sentry is a cost effective tool for monitoring mission critical database servers where you don't have a team of deeply experienced DBAs. It effectively allows you to buy DBA trouble shooting skills. You still need to have engineers with a good understanding of SQL Server - but SQL Sentry provides them with the tools to be able to trouble shoot SQL Performance problems.
We had an application database that would occasionally spike to 100% CPU. SQL Sentry helped us identify which database was consuming the CPU. That was pretty straightfoward. What was not straightforward was figuring out why the database was consuming 100% CPU. Every indicator we could see on the surface was that the workload had remained consistent. The volume of requests and type of requests going to the web application were consistent. The volume of SQL transactions was consistent. Where SQL Sentry provided it's worth was in Top Queries. It showed us that one specific query was consuming all of the CPU. When we looked at the execution plan that was captured by SQL Sentry we could see that a sub-optimal plan had been cached. We were then able to flush the cached plan and a new more optimal plan was cached. This returned the database CPU consumption to normal. We then worked through updating the SPROC so that a sub-optimal plan would not be cached. SQL Sentry Top Queries and execution plan capture were critical to handling this incident.
Read Zachary Peer's full review
Thomas Parsonage profile photo
April 27, 2016

Review: "SQL Sentry, the first line of defence for your server"

Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry was purchased to monitor our new Business Intelligence Infrastructure. The tool allows us to see at a glance if we have any performance issues; we also utilise the alerting feature heavily to make sure that even when we are not in the office or connected we can still see how the server is performing.
  • Alerting features are a must, it takes a little while to tune them to your system but once you have them, they will save you and your team countless hours of recovery / server maintenance as you can stop the issue before it even becomes one.
  • Performance Manager is great to understand not only how your server is performing now but also any time in the past. We utilise this to drill into any unusual activity with ease due to the UI being so intuitive and self explanatory. Again a massive time saver
  • The cloud based reporting is very useful for a quick health check when you are not near your laptop.
  • The event manager can really cluttered when using it on a business intelligence server with jobs running throughout the day. It would be great to see this in a different visualisation that could really help you spot the key hot spots, possibly create an impact metric that displays the jobs size depending on how much resource the job took to complete.
SQL Sentry hits the spot when using it for a business intelligence server.
We had a long running query that locked a lot of the schema out of hours, with SQL Sentry not only could I identify what was blocking everything else but also view the specific part of the code and it's execution plan, look at what else was running at the time and then tune the SQL as well as reschedule some activity.
Read Thomas Parsonage's full review
Ashish Upadhyay profile photo
April 26, 2016

SQL Sentry Review: "SQLSentry Performance Advisor helped me manage my SQL Server environment"

Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Sentry Performance Advisor has been used as a primary monitoring tool for our production environment, it has helped us a lot with troubleshooting bottlenecks, finding performance problems, resolving blocking etc. We're using this tool across the whole organization and monitoring around fifteen large production SQL Servers.
  • I can see global view of all my monitored servers on single screen with CPU, Memory, Disk & network usages based on last sample or even historical for upto 3 days. Also if there is an area of concerns Performance Advisor will highlighted that server with red or orange depending upon the condition or level of concerns.
  • Blocking and deadlock situations are clearly visible which gives insight to resolve conflicts.
  • Disk Activity section provides clear visibility of each and every data files (.MDF, .LDF & .NDF) with the level of activity (Read & Write operations) which is very helpful for us for our OLTP environment to monitor and keep a watch on response from storage system.
  • Alert system is good.
  • I believe SQL Sentry has good alert mechanism but still I see a room for improvement, for example recently we tried to change subject line of specific type of alerts (for example server offline, or high CPU utilization etc.) to make it more meaningful for our organization and we had hard time doing this.
  • Reports need some improvement, reports are good but I believe few summary report need to be added which reflects overall performance of the environment. For example downtime report is available which serves the purpose of availability but having similar reports to reflect high level performance reporting would be helpful.
  • In the global view under the disk section ms/IO shows the values based on the sample and changes the color from depending upon threshold which is a good feature. Also, upon right click it allows to generate quick report which again shows time & value for ms/IO. So, it would be a great feature if SQL Sentry can add a functionality to show which particular LUN(s) is responding slowly.
I believe it is a great monitoring tool for highly transaction environments.
We had performance issue with one of the drive which was housing files for tempDB of one of our critical SQL Server and we always had performance issues with that server. After the implementation of SQL Sentry Performance Advisor, we were able to identify that problematic disk and resolve that issue. This is one of the best example I would like to share here.
Read Ashish Upadhyay's full review

Feature Scorecard Summary

Performance dashboard (81)
9.5
Intelligent alerting (77)
9.5
Top SQL (81)
9.9
Historical trend data (79)
8.8
Virtualization support (50)
9.2

About SQL Sentry

SQL Sentry is designed to simplify performance tuning by visualizing where problems exist for faster resolution. This solution aims to help users streamline their defragmentation process and query tuning all in one place.

The vendor says they have combined all SQL Sentry tools into a single unified solution to help users monitor and optimize the Microsoft data platform.

According to the vendor, this solution includes everything for: SQL Server and Windows Performance Monitoring, Event Management, Index Defragmentation and Query Plan Analysis, with Desktop, Web, and Mobile UIs.

SQL Sentry Features

SQL Performance Monitoring Features
Has featurePerformance dashboard
Has featureIntelligent alerting
Has featureTop SQL
Has featureHistorical trend data
Has featureVirtualization support
Additional Features
Has featureQuery Plan Analysis
Has featureBlock and Deadlock Analysis
Has featureEvent Calendars
Has featureAdivsory Conditions
Has featureAlwaysOn Availability Groups Monitoring
Has featureIndex Analysis
Has featureStorage Forecasting

SQL Sentry Screenshots

SQL Sentry Videos (2)

SQL Sentry Integrations

SQL Sentry Competitors

Redgate, SolarWinds, Idera, Quest

Pricing

Has featureFree Trial Available?Yes
Has featureFree or Freemium Version Available?Yes
Has featurePremium Consulting/Integration Services Available?Yes
Entry-level set up fee?No
EditionPricing DetailsTerms
SQL Sentry$2,495per instance
SQL Sentry Annual Maintenance$499per year
SQL Sentry Subscription$125per month; billed annually
SQL Sentry Essentials$995per instance (up to 5 instances)
SQL Sentry Essentials Maintenance$199per year
SQL Sentry Essentials Subscription$50per month; billed annually
Plan Explorer (SQL Server Query Tuning)$0free

You can trial SQL Sentry Essentials for free at www.sentryone.com/essentials-trial , and SQL Sentry at my.sentryone.com/trial.

SQL Sentry Customer Size Distribution

Consumers
5%
Small Businesses (1-50 employees)
20%
Mid-Size Companies (51-500 employees)
50%
Enterprises (> 500 employees)
25%

SQL Sentry Support Options

 Free VersionPaid Version
Phone
Live Chat
Email
Forum/Community
FAQ/Knowledgebase
Social Media
Video Tutorials / Webinar

SQL Sentry Technical Details

Deployment Types:On-premise, SaaS
Operating Systems: Windows, Linux, Amazon RDS and EC2, Azure SQL DB Managed Instance
Mobile Application:No
Supported Countries:United States, United Kingdom, Australia, South Africa, Canada, Mexico, Brazil, Poland, Germany, Italy, France, Spain, Sweden, Norway, Russia, Ireland, Austria, Switzerland, Paraguay, Costa Rica, Denmark, Finland
Supported Languages: English