Relational Databases Forum

3a65612a 95d7 4264 9fd1 96557f672635 avatar
Head - Server and Storage at a financial services firm with 1,001-5,000 employees
Nov 06 2017
Does running Oracle 11g and 12c databases under OLTP type workload on SPARC architecture really offer performance benefits compared to a similar specification Intel based server (keeping the Core-count same to remove the licensing from the picture)?
Anonymous avatar x30
Bobin VargheseIn my experience SPARC provides far better performance than x86 based server. Databases are more responsive and way quicker to start. Recently, I had the privilege to run 70(Yes, 70) databases on a single E25k SPARC server with around 256GB RAM. No issues whatsoever. Try running half of that on a x86 based server and it would be a disaster. Having said that, I am sure you must have read that Oracle has stopped further development of SPARC which indirectly means that it will stop SPARC sooner rather than later. Would you still want to use/move to SPARC servers?
Anonymous avatar x30
Miguel A AlvarezHi, The answer for your question is a simple: yes, it performs better on the same configuration memory/cores. The reason is simple: sparc performs much better than intel, and the architecture designed by oracle to get the most of their processors it is really good. Besides, using red hat as a SO, on intel processors, the gap is shorter. But the winner is SPARC.
4258f904 f643 4abc 9f7a 068ee8459253 avatar
Project Manager - HCM Solutions at a tech vendor with 1,001-5,000 employees
Nov 05 2017
Looking for a comparison of Microsoft SQL 2017 and SAP Hana.
Mordechai danielov li?1414330111
Mordechai DanielovSAP Hana under the full use license can support non-SAP applications that's not the problem, but I don't think anyone would want to do it because of its high cost. Also notice that SAP HANA uses it's own SQL flavor and has a limited choice of drivers.
Fb46d0d8 8214 4162 830d 0932da5c1e6d avatar?1454096273
Sangeetha RamamurthyThere are several similarities b/w the relational databases. I would go with one or the other only based on the use-case. This particular tabular format helps compare and contrast the features.
Bc4da1b1 bd0c 4bc3 b630 4afbd27cfe03 avatar
Royden AkerleyDP DHL does use both tools but the use is largely restricted by business function. To begin with I must set the context of which we use these tools. I need to point out we also use Software AG's Terracotta and Mongo db for in-memory solutions as well as SAP's Hana. Terracotta is used for persistent memory associated with our ESB and Complex Event Processing, while Mongo db is primarily for report and user facing applications. Hana is largely confined to within the Global Business Management with limited use outside that division. All in-memory solutions are considered secondary drawing their data from relational data stores which is usually denormalized to support rapid access. MS SQL is used for departmental level data stores and usually for non-mission critical applications. We have as primary data stores Oracle, Informix and Teradata (for data warehousing). MS SQL is usually defined as a functional data store (not really an ODS) and rarely connected to on-line transactional processing, but frequently as a localized data mart or in a supporting function. The difference we have experienced between the tools was on speed of resolution for on-line requests, and if atomic, relational data was needed. Hana worked well for us in areas where using large volumes of aggregated and unstructured data for analysis. It was primarily tied to our SAP ERP solutions with the native integration a prime feature. We rarely found it useful in big data search as we tend to approach big data in a non-standard and proprietary approach. Hana allowed close integration s well to a number of statistical modeling tools that support the financial analysis and forecasting. MS SQL excelled in the areas of data quality validations, drill down of finite sets of data for a given subject area (limited business objects over small temporal windows). It integrated well and was actually a necessity for the use of the Microsoft BI stack, and tools. These are usually locally enabled, along with Tableau and Qlik-View by business functions. However, once “productionizing” the analytics we move to in-house developed solutions to reduce license and run costs. Each tool has its own niche within DP DHL, and there is no view to replacing one with the other.
Anonymous avatar x80
Practice Manager Business Development Central & Eastern Europe at a tech vendor with 1,001-5,000 employees
Hello, I am looking for use cases/references for embedded solutions with Informix, especially in the plant construction, manufacturing and car manufacturing / automotive supplier. Thanks, Milko

Sign Up with Email