RE: [Semi-OT] SQL Server tools for the Oracle DBA
Date: Wed, 8 Apr 2009 13:27:49 -0500 (CDT)
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.