RE: [Semi-OT] SQL Server tools for the Oracle DBA
Date: Wed, 8 Apr 2009 13:23:46 -0400
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.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Wednesday, April 08, 2009 11:08 AM To: Oracle L
Subject: [Semi-OT] SQL Server tools for the Oracle DBA
Being a Solo DBA, I also have to bear with managing SQueaL Server
(yes, they warned me of that before I accepted the job 2 years ago!). With
Oracle, we had purchased the Diag and Tuning Packs, so it made Grid Control
an easy ("already bought") choice to use to centrally manage/monitor our few
I need something similar for SQueaL Server, albeit with zero budget.
tested the SQueaL Server GC plugin and am not impressed at all. Not only is
it not worth the $1800/CPU plus the requirement of installing and managing
the Agent on every SQueaL Server box, but the outright bugs I've found leave
me doubting Oracle Corp's commitment to the plugin.
The idea I'm implementing is a repository of tables in a DB connected by
Linked Servers using queries to pull the fun management-related data,
I can then write fun SSIS stuff to help me manage all the SSs without the
need to constantly touch each DB.
Any other Oracle DBAs using/contemplating/bemoaning anything similar?
Anyone written their own GC plugin (I'm looking at the PPT on extending
from Alex of Pythian now)?
http://www.freelists.org/webpage/oracle-l Received on Wed Apr 08 2009 - 12:23:46 CDT