General discussion

Locked

SQLServer 7.0 vs Oracle - Scaleability?

By gary.ligon ·
Where can I find reliable data on sizing for databases in the NT world? The question centers on development - NT/SQLServer or UNIX/Oracle. Can NT support warehouse size applications? Can NT support on-line high volume applications at the same time you are running warehouse functions? Does size matter?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQLServer 7.0 vs Oracle - Scaleability?

by darren.marynchak In reply to SQLServer 7.0 vs Oracle - ...

My answer comes more from the UNIX/Oracle perspective... It really depends on how you define 'Warehouse Size'. I can say from a scalability perspective, you're better off with Oracle on Unix than Oracle on NT. But again, I think you need to throwout some numbers (MBs, GBs, TBs, you get the picture). Not sure how SQLServer compares to Oracle but, besides cost, I'd say SQLServer will not hold up very well in that comparison.

Regarding the last part of your question (OLTP -v- Warehousing), it's been my experience that the two are very different. You can configure and tune to one or the other but not both. You can setup an environment to handle both but it will be a marginal performer at each task. The problem is the each application type (OLTP -v- DW) has it's own chanllenges. Since the server has finite resources, those resources need to be directed at the specific challenges, but not both. Pure OLTP is typically numerous (short/quick) amounts of work (many users / lots of activity). Pure DW typically has fewer users, periods of loading (DW re-fresh) and the user activity tends to be fewer / more complex (long running) queries.

The final question, does size matter, the obvious answer is yes. But again, what kind of size are you talking about?

In summary:
- don't mix&match OLTP and DW application on the same database / server.
- Oracle is better than SQLServer (in my humble but adittedly tainted opinion)
- UNIX is better than NT, depending on cost,expertise,scalabiltiy ceiling...

Collapse -

SQLServer 7.0 vs Oracle - Scaleability?

by gary.ligon In reply to SQLServer 7.0 vs Oracle - ...

Poster rated this answer

Collapse -

SQLServer 7.0 vs Oracle - Scaleability?

by gary.ligon In reply to SQLServer 7.0 vs Oracle - ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums