Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Diagnostic Manager Expand / Collapse
Author
Message
Posted Thursday, December 21, 2006 4:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:08 AM
Points: 2,674, Visits: 695
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.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #332090
Posted Monday, December 25, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #332740
Posted Friday, February 02, 2007 8:49 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, January 11, 2012 2:47 PM
Points: 681, Visits: 10,845
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
Post #342262
Posted Saturday, February 03, 2007 9:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:08 AM
Points: 2,674, Visits: 695

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.



The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #342291
Posted Monday, February 05, 2007 10:38 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, January 11, 2012 2:47 PM
Points: 681, Visits: 10,845
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
Post #342539
Posted Tuesday, February 06, 2007 9:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:08 AM
Points: 2,674, Visits: 695
  • 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?



The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #342841
Posted Friday, February 16, 2007 2:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:12 PM
Points: 134, Visits: 319

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

 

_WM




Post #345614
Posted Tuesday, February 20, 2007 3:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 19, 2008 9:50 AM
Points: 15, Visits: 7

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

Post #346181
Posted Tuesday, February 20, 2007 3:05 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, January 11, 2012 2:47 PM
Points: 681, Visits: 10,845
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
Post #346185
Posted Tuesday, February 20, 2007 3:16 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:08 AM
Points: 2,674, Visits: 695
I have in several client sites.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #346189
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse