Redgate SQL Monitor vs. Splunk Enterprise

Redgate SQL Monitor is well suited for database administrators or companies who implement software that relies on SQL servers. It will help them test new changes and ensure this will not impact the performance of their software. It is a last resort for MSPs to use to get to the bottom of an ongoing performance issue with their SQL server.

Incentivized

Pros: Splunk is very well suited if you have multiple log sources of related data. All of them can be correlated and tasks can be automated based on the requirement. Other than alerts, Splunk can also run a specific script of your choice, based on some defined conditions. Cons: If you have a few logs but a large number of log sources, Splunk can be very expensive.

Incentivized

• It will tell you if your server is under attack.
• You can quickly see how your server is performing and which queries are taking the longest
• I gives you the feeling that you are in control of your database, that you know what is going on for when they users ring up and tell you that the server is slow

Incentivized

• Real-time + Scheduled alerts - i-e you can set up alerts which are actively monitoring your logs
• Pretty good response time for search results. With our key/value logging, Splunk makes it blazing fast to query the data.
• Dashboards provide insights into historical data
• Love how Splunk indexes all of the data and provides keys to search on

Incentivized

• Incremental releases can be buggy
• Isn't the best for pinpointing performance issues
• Web interface can be sluggish

Incentivized

• At times some queries can run slowly if indices are not on a portion of the query you use.
• Setup time initially can be difficult if your logs aren't stored in common locations or in a common way to write the log.
• Ability to ingest logs from different locations without having to change code to put logs in a certain place (pro and con).
• Searches can be a bit more difficult to look through if your log isn't pulled in a manner that is easy to read through splunk.

Incentivized

We are using Splunk extensively in our projects and we have recently upgraded to Splunk version 6.0 which is quite efficient and giving expected results. We keep track of updates and new features Splunk introduces periodically and try to introduce those features in our day to day activities for improvement in our reporting system and other tasks.

Access to metrics is simple but I like easy access to top SQL

You can literally throw in a single word into Splunk and it will pull back all instances of that word across all of your logs for the time span you select (provided you have permission to see that data). We have several users who have taken a few of the free courses from Splunk that are able to pull data out of it everyday with little help at all.

Incentivized

When properly setup and configured, Splunk is extremely reliable.

Incentivized

Fast support responses from Redgate

Incentivized

Splunk maintains a well resourced support system that has been consistent since we purchased the product. They help out in a timely manner and provide expert level information as needed. We typically open cases online and communicate when possible via e-mail and are able to resolve most issues with that method.

Incentivized

The online course was simple clear and described the main capabilities of the solution. There is also an initial module that can be done for free so anyone can familiarize themselves with the functionality of this solution. On the other hand, however, there could be more free online courses. Maybe even with a certificate, this would broaden the group of people who are familiar with the platform while increasing familiarity with the solution itself.

Smooth without too many major issues.

Incentivized

Redgate SQL Monitor is a lot cheaper than SolarWinds Database Performance Analyzer. I prefer the SolarWinds' design and that it offers integration with other SolarWinds products we already use. SolarWinds supports more than SQL servers (Oracle, MySQL, Maria DB, IBM DB2) and the analysis seems to be much better. The Spiceworks SQL Server monitoring is a free tool and is ideal for monitoring small business SQL instances.

Incentivized

I wanted to learn a new language that I can quickly master and implement. Splunk is easy, fun to use and best of all, it can be developed in hours not days or weeks. Splunk is fundamentally a programming language that is minimal but yet powerful enough to collect, analyze and visualize data.

Incentivized

Splunk can scale in to the petabyte per day range which of course is awesome

• The quality of the product and give a negative investment impression, on the plus side when it does work it is a god send.
• Day to day tasks as made simpler, and a feeling of security of realised. Just don't change anything.

Incentivized

• Overall very positive. It has provided visibility to what is going on within our network.
• One drawback is the time it takes to get up to speed with the application, but this is up to the user, and Splunk education is excellent.
• In my field, IT Security, there are few other friends to have in your back pocket better than Splunk. They are just that good.

Incentivized