December 2, 2008 at 8:00 am
Hi, I recently recommended that my company purchases Idera SQL diagnostic manager. Then I saw on the Internet SQL Power Tools. Does anybody have experience with both and could recommend one or another? thank you.
LL
December 2, 2008 at 12:10 pm
Have Diagnostic Manager currently. Dropping it. Looking for something else, even with a higher price point.
Speaking to the Idera reps there have been major improvements in the latest release. Just not feeling good mojo though.
December 2, 2008 at 12:19 pm
Hi, Nicholas, thank you for your reply, but what exactly you didn't like in Idera? I also heard from their reps about improvements, we haven't purchased it yet and if we do it will be the latest version, agentless, no overhead, a lot of stats to monitor... But today I saw this SQL Power Tools and liked what they say about best/worst performing queries. I don't think Idera tool has this feature. But I am not sure how they can monitor the queries without running a trace.
December 2, 2008 at 12:31 pm
What version of SQL are you running?
I know that they run a large number of queries against the servers to produce data, you can adjust the refresh interval (thus the number of calls to the server), however I have seen several cases of the tool blocking other items. It does have the ability to detect the worst queries, although it isn't the best at doing so. In SQL 2005 and 2008 you can use DMV's to get you the self same thing.
I've been a user of the Idera tools for several years, however a lot of turnover in the company, the product bugs I have encountered (admittedly which get fixed) and the way too frequent releases (which is a nightmare when managing a lot of instances) have led me to look other places.
Even a long chat with Idera reps (and a product manager) didn't leave me with much faith for the future of the tool.
December 2, 2008 at 12:54 pm
now it is sql 2000, sp4.
December 2, 2008 at 1:03 pm
I am running on the same currently.
I am a version behind on the tool, but currently it connects, runs queries and disconnects. The data is displayed in a dashboard, which can be very confusing and doesn't always show the right data.
They have downloadable trials of the product, pull it down and try it on a dev or stage system, it might be just what you are looking for. Don't make it the only one you try. Figure out the price point that you can afford, identify all the components you want to monitor, break it down to a list of essentials, good to haves, and would be nices. Find all the products that feature your needs and fit the price. Then get trials of all those.
My thoughts and bias aside, this might be the best tool for you. Like a suit, find the one that fits you the best and not just the first one that you might see on the rack, or just go to the tailor if you can afford it and get a custom made, fitted deal.
December 2, 2008 at 1:13 pm
I already tried it on dev environment and also I tried Quest tools. Overall, including installation, readability and functionality I preferred Idera over Quest. But I understand that 2 weeks is not enough to discover downsides that I am sure exist. We always want more for less!
December 2, 2008 at 1:16 pm
Of course.
An advantage to Idera is the cost, you could do an extended trial for a very reasonable cost to one instance.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply