| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:opinion needed: when sqlserver & not Oracle
Kip,
I believe you have a good level of suspicion on the subject. I run a SQL*Server 7 setup at home mainly to have exposure to the demon, I also run Oracle on Linux at home. On a head to head comparison of TX volume/speed I'd rate them at more or less equal (especially since the Linux box is an old 486/66). The NT install has been more or less stable but of course it is not running 24x7, and the Linux has been 100% stable & runs my proxy server so it is 24x7. SQL*Server has bombed irreparably several times in the past, requiring a rebuild/restore which I would NOT recommend for the uninitiated. It does appear to be suspect to large amounts of transactions in a short period of time. Bulk loads are not it's forte. Oracle on the other hand has been ticking along for at least 2 years now with no maintenance required other than the periodic backup which is automated. On the issue of cost though the Linux install does have an advantage, mainly because Linux is basically free, save for the manual that has minimal cost & is not a bad item to send to that remote site. And Oracle on Linux is a bargain even if you have to do the internet license since Intel processors don't come up to the speed of certain HP-V class boxes. (Simple math, by Oracle's license standards a license on a single processor 600 MHZ machine is cheaper than a license on a PA-RISC 750x6 machine.)
Recommendation: Help save the world from the Evil Gates, go with Oracle on Linux.
Dick Goulet
OK,OK, I'll get off of the soap box now!! :-)
____________________Reply Separator____________________Subject: opinion needed: when sqlserver & not Oracle Author: Kip.Bryant_at_Vishay.com
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).Received on Wed Aug 23 2000 - 08:23:26 CDT
 |
 |