November 14, 2018 at 1:44 am
Hi,
we are testing the red gate sql monitoring solution. It locks very good, but we had to explain, why to buy a new monitoring solution, because we have HP OMI SQL Management Pack in use.
Are there some links, to get some good reasons to use red gate, instead of HP OMI?
Are there some gartner magiq quadrants?
Maybe there are some good links from red gate, to convince our decisions makers.
Thanks,
Kind regards,
Andreas
November 14, 2018 at 3:23 am
Hi Andreas
We don't have a direct comparison with HP OMI nor any Magic Quadrants we're in for SQL Server Monitoring at the moment, however there are some resources available that we've written with decision makers in mind that may be of use to you:
4 Pillars of SQL Server Monitoring: this gives a great overview of the importance of dedicated SQL Server monitoring and the fundamentals behind the process, plus it's written by the experts: Rodney Landrum, Phil Factor, Kathi Kellenberger and Grant Fritchey.
The Strategic Value of Monitoring SQL Server: This guide by Rodney Landrum covers the reasons for getting a dedicated SQL Server monitoring tool and how to get your boss to agree.
Personalized ROI guide: this simple ROI calculator will give you an estimate of how much money and time you will save using SQL Monitor, and you can download the results into a personalized guide that you can share, which has loads of additional resources on why to choose SQL Monitor.
I think those are the best resources we currently offer, if you'd like something more tailored, such as a proof of concept for your organization, please let me know and I can get that arranged for you.
Any other questions please don't hesitate to get in touch.
Best wishes
Jamie
November 14, 2018 at 11:07 am
I've never seen HP OMI SQL Server Management Pack in action. I went to the HP documentation, but the page won't load, so I can't comment on any differences.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 14, 2018 at 11:19 am
Ah, tracked down a copy of the reports possible in the HP thing:
Active Connections • Database Status • Filegroup Space Usage • Locks Wait Rate • Microsoft SQL Server Connection Check
• Microsoft SQL Server Documents • Mirroring Status • Network Statistics • Processes Blocked • Replication Agent Status • Replication Latency • Server Statistics • Server Status • Transaction Log Space Usage • Transactions Active • Users Connected • Virtual Device Space Usage
Without a full assessment of the tool, I'd be hard pressed to list all the differences, but, what I don't see up there are individual wait statistics and query metrics. I don't see baseline capabilities. I also don't see Availability Groups, Azure, or virtual machines (possibly listed elsewhere).
This tool looks very similar to the Microsoft Operations Manager. Like OM, this HP tool probably hits the high points of server and disk management. However, like OM, I suspect this HP tool doesn't understand, or reveal, a lot of the SQL Server internals, especially query metrics, wait stats (for a given query or at a moment in time, it clearly collects waits), execution plans and others.
This is the documentation I'm using. Searching it, I don't find any of the things I listed as missing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply