RE: [Semi-OT] SQL Server tools for the Oracle DBA

From: Rich Jesse <>
Date: Wed, 8 Apr 2009 13:27:49 -0500 (CDT)
Message-ID: <>

Hey Matt,

I'm looking for very basic management with reactive notifications (database down) and some proactive notifications (data drive is 95% full). Performance? I don't monitor much of it now as there's very little user complaints of the SQueaL apps with regard to performance, so that's not a priority for me.

SS Damagement Studio is OK if unbearably slow at times. Perhaps I need to investigate further (including licensing), but it seems cumbersome with regard to centralized reporting. Metrics like some of the dashboard of GC -- any job failures, backups, warnings, etc. for a group of servers isn't there or perhaps I just haven't seen/used it yet. The only way I've used it is to connect to each server and run queries/reports for each. Time-consuming to say the least.

I also use the freeware Toad for SS daily. It's limited to two concurrent connections to different servers. It's great for the few DBA scripts I write/plagarize, but not so much for server management. For that, the commercial version would be required, which also has nice toys like a job manager.


> What sort of managing are you looking at doing? Performance stuff? For
> day to day activities, SQL Server Management Studio isn't terrible, and
> there's a freeware Toad for SQL Server.
> Thanks,
> Matt

Received on Wed Apr 08 2009 - 13:27:49 CDT

Original text of this message