>Hello
>
>We are desigining an application and we are planing to use Oracle 8i for a server.
>
>My question is about maintenance, after we deploy the application for the user which is basicly is a single user with potential to many users, in that environment what do you think the server less needed DBA intervention Oracle8 or SQL server???
>
>Do you know of any white paper on this subject?
>
>Thanks
>Mo
SQL Server 7.0 is quite easy to maintain compared to Oracle. You can start a logging program in SQL Server, let it run for a month, and then pass the log file into a performance analyzer and it will suggest indexes to create and remove. Just click OK and it does it.
The project my company is working on was going against an $250K Oracle server and was not performing well at all. We dumped the data into a $10K SQL Server box and it performed better than the oracle box. We felt that the oracle box was not tuned properly (even with serveral inhouse oracle dba's), so we called in an expert oracle guru at $250 an hour to check our stuff and he could not find anything wrong. He said to re-write the app in an oracle native format and not use ODBC.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement