|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 7:29 PM
Points: 769,
Visits: 214
|
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:26 PM
Points: 2,642,
Visits: 4,960
|
|
running "worst performing queries, traces and batches" can be an overkill for the busy production server, since SQLDIAG is running traces on a target server. The good part that you can turn them off completely or run only at certain times. Nice product, but pricey, when it comes to adding more servers to monitor...
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Saturday, July 11, 2009 12:35 PM
Points: 25,
Visits: 10
|
|
I must admit, using Idera DM makes life a lot easier for any DBA. Some DBA might call you lazy for using a tool like this, but I seriously disagree. DM can give you a deep insight into any SQL server, almost instantly. My former CITO's opinion after about 3 months of using DM was, how did we ever get along without it.
I've been using DM for almost 12 months now (since 3.5). I recommend it to all my clients (I think I should start charging Idera some commission).
It is true that in same cases it might cause overhead on your server, but finding a solution to a problem, that otherwise might have been eluding you, is always worth that cost.
|
|
|
|