Post reply

SQL Diagnostic Manager

  • December 21, 2006 at 4:03 am

    #116737

    As this is a new forum point I'd just like to say how much I like this product, I've used it since the days of it being SQL Probe, 199? , can't remember now.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • December 25, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • February 2, 2007 at 8:49 pm

    #687614

    I have this product as well...however, some days I wonder if I am not using it to its full potetial.  What sort of things do you use this for?  How often do you use it for that?  (daily? Weekly? yearly?)  I know that I have had to create some "moving" views to make the data more useable, as it logs everything to a table called <table><year>_<month>...

    -- Cory

  • February 3, 2007 at 9:06 am

    #687632

    I use it for the alerts, the worst performing, growth, statistics, viewing user processes - it's a very useful tool to have running. Never had to worry about changing the data - view stats is pretty good.

    Extracting the worst performing could be easier / better.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 5, 2007 at 10:38 am

    #687838

    Here is what I use - I do have alerts set to email...And every morning I run "Reoganization", kick out the tables that are to large and will not complete in the 10 min per table time restriction, and allow that to run...Other than that, I do not do a lot with this, but want to do more - it looks like it really could do more...

    -- Cory

  • February 6, 2007 at 9:29 am

    #688084

    • I don't use it for rebuilding indexes or stats.
    • I view extract worst performing for optimisation
    • I view table growth/ useage of text columns and will look at indexes and sizes on tables
    • I view growth stats for databases
    • I make use of running processes and the drill down to individual users
    • I use the output of the proc cache and stats as well as the memory breakdown
    • I look at cpu and io, page life and some of the others.
    • I use all the alerts for blocking, deadlocks, cpu, failed jobs, longin running jobs, open trans
    • I use the combined alert log for all servers

    how's that for a start?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 16, 2007 at 2:30 pm

    #690331

    I also have the tool but don't use it as often as I should. Thanks for the advice

     

    _WM

  • February 20, 2007 at 3:01 pm

    #690763

    For those of you who have this product, would you buy it again or would you look at another product?  I tried it out and liked it, just wondering what your thoughts are after working with it awhile.

    Thanks,

    Bart

  • February 20, 2007 at 3:05 pm

    #690765

    Idera has a whole suite of products...and I have been looking at quite a few of them.  This one, when I need it, hands down, I would buy it again...now, it runs in the background, lets me know when things are going sour, and is always there to help me out.  I like that it saves stat data in the database, I have done some nifty things for trending out size and such.  I like it, yes, I would buy it again.

    -- Cory

  • February 20, 2007 at 3:16 pm

    #690767

    I have in several client sites.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • May 2, 2011 at 2:34 pm

    #1318732

    We are using the Idera SQL Diagnostic tool for various things.

    One of them is to put the servers in 'Maintenance mode' prior to going into our maintenance window.

    We have a total of 57 servers licensed and right now I'm setting each one individually in 'Maintenance mode'. Has any one figured out a way to do all servers at once?

    Thanks

  • September 5, 2011 at 8:17 am

    #1377055

    I am having a particular situation with the Diagnostic Manager.

    I have a scheduled Rebuild Job on my server, and it runs sucessfully, but with no results. Only if I do the Rebuild from the interface the % of fragmentation change.

    Why is that?

    I have also a T-Sql Rebuild Job, but also seems not work.

    Any Ideas?

  • October 12, 2012 at 2:28 pm

    #1548835

    You can do this way:

    This is one time effort and prepare the script for all servers in same way.

    update MonitoredSQLServers set MaintenanceModeEnabled = 1 where InstanceName = 'ServerName'

    Thanks,

    Ashok

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply