Database serving
Databases often replace many of the low-level functions of the operating system, and some databases don't offer a choice of OS. Keeping this in mind, does OS matter?
Kevin McIsaac: As a DBMS (DataBase Management System) server, Windows 2000 will be suitable for 90 percent plus of all application scalability and availability requirements.
This will render Unix (other than Solaris) a legacy platform by 2004 or 2005, despite its more robust partitioning, workload management, and clustering.
Unlike the Web or app server tiers, the database must be run on a single image system, not a farm. This means that high availability and scalability must be built into the hardware and the operating system, which are Unix's traditional advantages.
However we believe that for 90 percent of the applications, Windows 2000 on an 8-way Intel system will provide sufficient scalability. While Windows 2000 fail-over clustering is still much weaker than Unix, it will suffice for those applications that required 99.5 percent availability, all but the mission critical apps.
Today, Linux is not a suitable operating system for a database server as it has very limited scalability and poor fail-over clustering support.
Dean Thompson: Databases can prove to be one of the most important assets that a company can have, and day-to-day use in the general operation of the organisation requires high performance.
The most suitable operating system for a database is Unix. DBMSes at the best of times are very resource intensive and are therefore not suited to operating in environments such as Windows NT or 2000 which are also resource hungry.
Database servers can commonly be found operating in a Solaris environment although there are a number of installations using them with Linux. Solaris is normally the recommended platform both for its reliability and for the hardware it runs on.
This combination proves to be very attractive to companies starting out with middle sized databases and which anticipate future growth. They can easily upgrade components of their database server, or there is the option of a "fork-lift" upgrade.
One factor that goes against Solaris is the cost of the hardware. There is a growing trend to consider Linux as a cost effective OS for database systems. Oracle has helped by offering a version of the Oracle DBMS server for Linux, allowing the use of commodity hardware to build systems with a reasonable level of performance at relatively low cost.
Both Solaris and Linux solutions are aimed mainly towards organisations with a vast amount of information to store.
Although not highly recommended, other solutions do present themselves to smaller companies that don't require all of the complexities that can be found in the commercial DBMS products.
Systems such as Microsoft Access or Microsoft SQL Server can provide small-to-medium-sized organisations with DBMS support, but their performance is also governed by the hardware that they are running on and any other software running on the same server.
Geoff Halprin: Microsoft's SQL Server serves the needs of small businesses well, but it does not scale to corporate needs. It is not industrial strength.
I am not aware of any large businesses using SQL Server beyond the workgroup environment.









I find the comments about Unix versions other than Solaris becoming considered "legacy" systems rather funny. I believe it was Solaris that recently announced they would no longer be developing a version for Intel...
Furthermore; the only reason there is an "OS War" is because Microsoft is more interested in making money and increasing their market share than meeting the needs of their customers. Linux is not the one with the "secret" protocols and undocumented "standards."