>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only