Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: opinion needed: when sqlserver & not Oracle

RE: opinion needed: when sqlserver & not Oracle

From: Richard Ji <richard_at_letsplay.com>
Date: Wed, 23 Aug 2000 09:19:59 -0400
Message-Id: <10598.115358@fatcity.com>


I don't see how SQLServer is as complex to manage as Oracle when it doesn't even have things like: Parallel Server, Bitmap Indexes plus tons of other missing things. And SQLServer automatically manages memory(SGA). I can go on and on but these are the few examples.

Richard Ji

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Paul van Dijken
Sent: Wednesday, August 23, 2000 6:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: opinion needed: when sqlserver & not Oracle

My $0.02 :

Sqlserver is just as complex to manage as is Oracle. You face the same problems with tablespaces, performance issus, backup strategies, etc. The management tools for Oracle however (either by Oracle or 3rd party suppliers) are superior to the management tools for Sqlserver. Don't forget, you also need a system manager to handle NT on the local sites as well. Having a system manager local, you can manage your databases around the world. Be prepared to work 24 hours a day though. :o)

Paul

-----Original Message-----
Sent: 22 August 2000 23:12
To: Multiple recipients of list ORACLE-L

Hi,

I don't want to start any holy war. I can just see the hackles rising over this one already.... I would just like an opinion on the following scenerio:

An application was developed without consulting anyone who might have to actually support it (that's a whole OTHER topic). It includes having a database on an NT server at various remote sites around the world where local
IT staff will be "minimal" or even non-existent. To make matters worse, I don't have any information about expected transaction volume or projected database size. I realize that I can do a fair amount of monitoring / administration remotely but, to be truthful, I'm not too crazy about supporting remote databases...especially if they are on NT instead of UNIX.

My question is this: at what point (txn volume / db size) would it be reasonable to push this back to sqlserver over Oracle? Or am I just being lazy? The assumption by management is that less well trained people could manage sqlserver and support problems would not come to me (ha ha).

Humbly,
Kip Bryant

--
Author:
  INET: Kip.Bryant_at_Vishay.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Paul van Dijken INET: paul.vandijken_at_sema.nl Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
Received on Wed Aug 23 2000 - 08:19:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US