Red Gate forums: SQL Index Manager

RE: Unable to detect databases

StephenC — Thu, 21 Feb 2013 18:21:47 GMT

Hi Mike,

I'm afraid that Index Manager doesn't support SQL 2000.

Very sorry this information wasn't included and I'll update the product page to reflect this.

Apologies for the inconvenience.

Regards,

Stephen

RE: Unable to detect databases

m_c_rose — Tue, 19 Feb 2013 18:44:40 GMT

Some additional information, if run Index manager on the server and enter the same information I get "Error: Invalid object name 'master.sys.databases'."
The servr I'm trying to diagnose is SQL 2000, I can't find anything statiing this product is not compatible with SQL 2000.

Unable to detect databases

m_c_rose — Tue, 19 Feb 2013 18:27:08 GMT

I am trying to connect to a remote database, when I enter the server and authentication info in the database drop down it shows
<Unable to detect databases>
From the same client I have validated i can connect with OSQL and can retrieve the databases with EXEC sp_databases, and SELECT name FROM master..sysdatabases.

Thanks
Mike R.

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

dlkj — Fri, 01 Feb 2013 11:02:35 GMT

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

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

PDinCA — Tue, 29 Jan 2013 19:17:42 GMT

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.

RE: SQL Index Manager - Feature Request - Process all Databases

StephenC — Mon, 25 Jun 2012 09:37:44 GMT

Hi Sean,

thanks for the request and I've added it to our system for review when further work is being done.

Have a good day,

Stephen

SQL Index Manager - Feature Request - Process all Databases

sean.alexander@ontario.ca — Fri, 22 Jun 2012 13:56:41 GMT

Alternatively, process databases in X Servers.