October 25, 2005 at 3:46 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/sqldiagnosticmanagerreview.asp
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
November 8, 2005 at 10:53 am
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...
November 8, 2006 at 7:07 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply