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

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

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[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

Hey all,

Being a Solo DBA, I also have to bear with managing SQueaL Server 2000/2005
(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
Oracle DBs.

I need something similar for SQueaL Server, albeit with zero budget. I've
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, where
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 GC
from Alex of Pythian now)?

TIA!
Rich

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 08 2009 - 12:23:46 CDT