January 29, 2014 at 1:54 pm
andre.quitta (1/29/2014)
I've also been evaluating monitoring software. Spotlight has changed to an instance pricing model, which could get pretty expensive pretty fast. We were quoted about $1,500 per instance. There's also no easy way to switch from one instance to another. We were thinking of using a floating license to install as needed. It would be a PITA to do so.I still like their tools, but they make it more difficult now.
Idera SQL Diagnostic Manager uses instance pricing, but you can switch from monitoring one server to monitoring a different server fairly quickly, without having to have a new license. If you have 10 licenses, you can monitor 10 different servers at any one time, and can switch to monitoring a different server without buying a new license.
You should be aware that Idera SQL Diagnostic Manager requires a SQL Server to store the data it gathers.
January 31, 2014 at 2:19 pm
We use Confio Ignite and Dell SQL Spotlight Enterprise. I like Ignite's breakdown of the SQL analysis, Spotlight for overall monitoring and alerting.
February 3, 2014 at 2:10 am
I have used ignite and good for performance perspective i.e. long running queries.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 3, 2014 at 10:53 am
We use SQL Sentry and are very satisfied with it. We were going through the same exercise of trying to find one and this came recommended by a speaker at a local PASS meeting.
It runs as executables and doesn't require a web server for reporting, which is a huge plus for me It also doesn't try to hide itself and can definitely handle lots of servers.
February 11, 2014 at 6:48 pm
Michael Valentine Jones,
Does SQL Diagnostic Manager allow you to continue browsing data collected from a server you no longer monitor?
Does anyone know if other DB monitoring products that allow this?
February 11, 2014 at 7:01 pm
brianpaulflynn (2/11/2014)
Michael Valentine Jones,Does SQL Diagnostic Manager allow you to continue browsing data collected from a server you no longer monitor?
Does anyone know if other DB monitoring products that allow this?
Yes it does, it actually has various "grooming" options which allows you to go back in time to view what was going on at that point in time.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2014 at 7:11 pm
Ed Wagner,
Does SQL Sentry allow you to continue browsing data collected from a server you no longer monitor?
February 12, 2014 at 10:00 am
I've been using Red Gate SQL Monitor for about 5 years. The price point is great, and it has never let me down.
I've come from days where I had to write scripts to collect statistical samples, schedule them, sitck em in a table, export them to excel, turn them into graphs and present, and although it's probably a good foundational skill to have, I'm over it. Now I just grab a cup of tea, check through my alerts, check through the analysis tabs, respond or adjust, and win.
There are some settings that need to be tailored so I would expect to realistically spend the first couple weeks learning the software through the documentation. Everything is pretty straightforward but you will need to make some adjustments for your specific environment. You also have the ability to create custom alerts (the user community has done a pretty good job at creating just about everything you could want). They also have a SSRS pack that I use to quench the reporting need of various management teams.
Why is it that people who can't take advice always insist on giving it? - James Bond, Casino Royale
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply