Re: Tools for DBA

Hey, James.

> Thanks very much for the advice. I'll go ahead and do this (though it
> means
> installing OpenVMS7.1 and buying more memory :-)

Yeah, isn't it fun upgrading your operating system, all layered products, all non-layered products, and THEN the database? Oh, and of course you only have the weekend to do it (of course, leaving time for a full backup (8 hours) before AND after the upgrade...

> I'm a pretty new DBA but I've been on a couple of training courses
> covering sizing, tablespace fragmentation etc, etc. It all seems
> quite straighforward (but tedious) to do this sort of thing, and I
> was wondering what else might be available for this and such things
> as trend analysis, problem prediction.
>
> I guess that the real question I should have asked is "What range of
> software tools are out there, and what sort of things do each of them
> do?". Is there a FAQ or other document available that can answer these
> auestions for me?

There is a software tool to do each of those jobs individually, and suites of tools that attempt to do ALL of those things, and few more, to boot. I haven't had the budget for the bigger tools, but I do use SQLab and AdHawk Spacer (www.quests.com) for performance tuning and space management. What is really nice about them is they will let you download real product, and give you a temporary key. Take 'em for a spin, kick the tires, and such. And you can download the software from their web page without having to sign a ton of paperwork.

And, no, I don't get any kickbacks, other than a beer at IOUW.

I don't know of any FAQ that you can read to help in this matter. However, I'm sure you will get some responses from people regarding the tools that they use.

Good luck.

Matt...

> --
> James "I'd rather fall off Ilustrada than ride any other horse" Petts
>
Received on Sun Jul 20 1997 - 00:00:00 CDT