Red Gate forums :: View topic - Unattended Mode, please... And a slew of other enhancements
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Index Manager
SQL Index Manager forum

Unattended Mode, please... And a slew of other enhancements

Search in SQL Index Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 503
Location: Costa Mesa, CA, USA

PostPosted: Tue Jan 29, 2013 8:17 pm    Post subject: Unattended Mode, please... And a slew of other enhancements Reply with quote

The more servers and instances an accidental DBA is tasked with overseeing, and the scant amount of time available to keep manually checking and running/scripting defrags, the more the tool needs an automated facility that will take the load off a person and put it on the machine!

The actions to take based on the nature of the fragmentation and the size of the index need to be very configurable, with multiple "policies" being available for, say, hourly, weekdays, weekend, et al, with the usual REORG, Rebuild, Rebuild Online options (watching out for doubling the data size for the PK - please warn us 'cos we forget sometimes). Frag measures for each policy, naturally, with guidance built in for the accidental folks... The list is LONG!

I've used Idera's Defrag Manager for over 5 years and typically look at it about once a month. It has some minor peeves but does the job well enough for a 250GB Cluster, but it is expensive @ 2 licenses per active-passive cluster!

When I looked at SQL Sentry's offering it looked a better option until they gouge your wallet with required, per instance, Performance Adviser licenses, which takes the price for a second site I'm responsible for that has three instances into the stratosphere comparatively.

Ola Hellengren's Solution is OK for starters but requires multiple job maintenance and manual scheduling using SSMS dialogs (slug, sub-par!) for any kind of regular maintenance practices like Defrag Manager delivers via a UI.

Then I saw Red Gate has a tool. BIG DISAPPOINTMENT that it is not much more than Idera's SQL Admin Toolset "Instant Defrag" tool - manual analysis, manual "do it now", albeit no scripting (run Profiler and snag the script!). At $295 for 25 tools it beats Red Gate in a price comparison, too.

I understand this is a fledgling product. It needs serious enhancement in the automation and configuration departments to be considered an option.

Would Red Gate expand the Uservoice site and the Product pages to show some kind of roadmap for potentially interested Red Gate customers?

If you can deliver a better product at a lower price that doesn't require me to purchase 6 licenses to cover 3 A/P clusters plus a QA/Performance box, you may well increase revenues substantially from SMBs.

Thanks for listening.
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Fri Feb 01, 2013 12:02 pm    Post subject: Reply with quote

Hi PDinCA,

First of all, thanks for giving SQL Index Manager a try and taking the time to send us your thoughts.

I agree that management tools break down in to two rough categories. Policy driven monitoring and scheduled style tools for pre-emptively finding issues and preventing problems, and point solution tools for interactively detecting and fixing a problem now.

The current version of SQL Index Manager is pitched firmly at the latter, both in scope and in price. It's been a great way to find out what people need from a maintenance tool. Some users really appreciate a simple "run it when I need it" tool while other are definitely more attracted to automation and monitoring based approaches to maintenance.

Once again, thanks for the feedback,

Daniel
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group