> > Our main R/3 database (4.72) is 1.2 TB running with MaxDB > 7.6 on Linux, we have avg. reponse times in the R/3 below 400 > ms serving 550 - 800 concurrent users, some of our > test/development/training systems are even bigger than that > (up to 3 TB after client copies); we grow each day between 2 - 4 GB. > > 1.2TB certainly sounds impressive. With 500-800 concurrent users do > you mean "concurrent activity" or "concurrent sessions / connections"? > And: is that response time comparable to what you see with other DB > products on same / similar hardware?
Yes - I mean concurrent activity. > For our type of application (kind of DWH with continuous updates) we > never saw performance that came close to the other DB's the products > supports - neither for insert / updates nor for queries. We also > experience significant higher growth of the database vs. other > products for our use case. We also had issues of joins returning > different results depending on some DB option for some version of 7.6. If the application is developed only or primarily on a specific database, it's pretty understandable, that other databases don't perform as the one, it was developed on. > DTS and backup / restore on SQL Server are also pretty easy - and > online operations as well. Backup/restore - yes - but not online (on system backing up, the second is using that backup *simultaneous* to restore). And that concurrence has an impact. > In my experience much of the patches are needed for auxiliary > programs. If you use the RDBMS only then that is pretty stable as far > as I can tell. The SAP note is not for auxiliary products but for the main RDBMS. Well, some of them are OLAP specific.. > Some of the features that I am missing from MaxDB: > > - Table partitioning > - Control over where data goes physically (tablespaces etc.) You don't have that control on SQL server too. Why do you think that is important? I mean, if you have ONE SAN connected, I wouldn't care if the data is read from oradata1/file1.dbf or oradata2/file2.dbf, there will be no "hotspot" on a SAN. > - Introspection capabilities that allow to tune SQL (tracing, > AWR etc.) In SAP area you have those possibilities too (SQL-Trace, "select * from running_commands" etc.), on non-SAP platforms I agree, it may be more difficult. > Also when I read recent postings here about version migration hassles > this does not give me confidence in robustness and manageability... Then try to read an Oracle forum of migration from 8i/9i to 10g... > That's my 0.02 EUR. It might well be that all these are non issues > for other deployments - that's simply what we have experienced. Yes - absolutely. What I want to say is that for a SAP R/3 system MaxDB is suitable also on medium to bigger sizes database. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-Competence Center/Basis Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com _________________________________ SIEGENIA-AUBI KG, Industriestraße 1 - 3, 57234 Wilnsdorf-Niederdielfen Kommanditgesellschaft, persönlich haftender Gesellschafter: Wieland Frank, Sitz der Gesellschaft: Wilnsdorf, Registergericht: Amtsgericht Siegen, HRA 3741 Der Inhalt dieser E-Mail und etwaige Anhänge sind vertraulich und können urheber-, patent- oder in anderer Weise rechtlich geschützt sein; sie sind deshalb ausschließlich für den bezeichneten Adressaten bestimmt. Sollten Sie nicht der bezeichnete Adressat dieser E-Mail oder dessen Vertreter sein, so beachten Sie bitte, dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung, Weitergabe oder Nutzung des Inhalts dieser E-Mail oder der Anhänge unzulässig ist. Wir bitten Sie, sich in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen und jegliche Originale und Kopien der E-Mail und der Anhänge zu vernichten. Wir weisen ausdrücklich darauf hin, dass die E-Mail-Kommunikation über das Internet unsicher ist, weil unberechtigte Dritte grundsätzlich die Möglichkeit der Kenntnisnahme und Manipulation haben. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]