NT is not bad as many think, as earlier I worked with one DOT COM, it had NT as their server because of their budget constraints. It really worked well. But as the DB size is growing then we felt it is doing that good. And if you want to compare with SUN definetly Sun is always supeiror than NT not only for Oracle for any Database.
Our database size will grow as a normal Oracle Governmental Financials implementation does throughout the course of several fiscal seasons. Currently the database is less than 15Gb, but with the additional modules (we are adding) will increase the size.
My concern about NT is not in DML performance, but yet the realiability of the database server staying up without a reboot. Much of what I have read indicates that there is a lot of server bouncing when you migrate to NT. With solaris, we never bounce the server and it is very stable.
[QUOTE][i]Originally posted by tamilselvan [/i]
[B]The question is not technology but how much money ($$$$$)can the organization spend for maintaining 50 GB DB in NT or in UNIX box. Then take up a decision.
The question should be how much time and money can the orginization lose when the database is down. All of a sudden, an extra $20K spent on a reliable server/OS is spare change.
In fact I had more problems with SUN machines than any other machines I used in my life.
You must have had a bad batch or something. I have worked with Oracle on a wide variety of platforms (Solaris, AIX, HP-UX, NT, Solaris x86, Netware). Sun/Solaris is, by far, the most reliable plaform for running Oracle databases. Out of those I have worked with, NT & Netware tie for the worst.
In an environment with 20 users and 50G of data, you might be able to get along with NT. If you schedule reboots every 7-10 days and put the data on a reliable RAID system you might be up aproximately 90% of the time. When you are talking about 300 users and 3TB of data that has to be accessed 24x7, it's a whole different story.
The reliability of SUN machines is lost today. I had worked with SUN 6500 /4500 /450 /420 servers and still am working with SUN. When ever SUN Enterprise Servers crashed, we did not know the reasons because the core dump could not be read by all IT staff. Later, one hardware specialist found that it was due to ECC problem, which was known to SUN before the machines were delivered to customers. After this news appeared in the Internet, SUN admitted that they knew the problem a year ago, but did not reveal to customers. So SUN delivered the faulty machine and the OS with bug. To our surprise, there were no patch available.
If I am wealthy, I drive BMW car, if I am not wealthy, I drive Toyota car.
Same way, if an organization gets good revenue and good profit, then it will buy IBM servers not SUN machines. SUN machines are suitable for medium size organizations where they still want to work with UNIX even though they are not reliable, and they can afford down time. NT is suitable for medium /small organizations where the database is around 50 to 100 GB.
Please go the following news:
I think that a lot of my concern comes from the fact that my organization has no MCSE's in house, and our system's support staff has never professionally administered Oracle on NT, but yet has two qualified SA's in the Solaris world that have experience in Oracle on Solaris.
To me the dollar for dollar savings would be to remain on the initial platform (solaris) for the upgrade to 11i since there are no qualified NT professionals on staff to properly configure the server.
Someone made the point that MCSE's are a dime a dozen nowadays, but that doesn't make me feel confident that the Oracle Server will be properly maintained.
We do have a server which goes down whenever it wants. Sun say`s it will fix next time it happens. I think 2/3 times its happened.
Still our guys goes for Unix not NT. DBA group feels good about Unix Platform (not in particular SUN/IBM/HP) from scalability/capbility/reliability/manageability perspective.
So, Our DBA group think Unix paltform is best for Oracle. Limitations are applications requirements again. Like the Oracle classified which says Internet e-business suite, one platform for every thing that you need. Moderate business and front end(VB,ASP) and Middle tier (IIS) and other Microsoft products then NT would be cost effective solution from integration of the products perspective.
As we know there will be pros and cons for everything and sometimes the experiences you have with that platform chages your mind.
Applications requirement, $$`s,user volume are the primary factors in deciding the right platform for enterprize.
Iam dealing with the same in recommeding the right platform for one of our 100GB database which can grow upto couple of 100`s in couple of years.