RE: [Semi-OT] SQL Server tools for the Oracle DBA
- From: "Matthew Zito" <mzito@xxxxxxxxxxx>
- To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- 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.
Thanks,
Matt
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
