How will a SQL database perform on Unix or Linux compared to Windows?

How will a SQL database perform on Unix or Linux compared to Windows?

We use a Windows XP network on which we operate our pre-paid electricity database. It is basically the same as a bank OTM environment, but it limited to my government agency's client base only. How will a SQL database perform on Unix or Linux compared with Windows XP? What other software will be needed to migrate to Unix? ...to Linux?

    Requires Free Membership to View

    Login

    When you register, my team of editors will also send you resources covering Linux administration and management; integration and interoperability between Linux, Windows and Unix; securing Linux and mixed-platform environments; and migrating to Linux.

    Cathleen A. Gagne, Senior Editorial Director

    By submitting your registration information to SearchEnterpriseLinux.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchEnterpriseLinux.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

As a general rule, a typical SQL database will not perform as well on a Windows Server as on Unix or Linux platform. It will not be as reliable, scaleable or secure. It's that simple and I don't know of any industry expert that would tell you otherwise.

On the hardware side, with Intel you are limited by the 32-bit architecture of Intel based servers, though that may change with the future availability of 64-bit on the PC. As an aside, I would say if you need to run your database on a Windows server, at least go to Windows 2000 or 2003; get off of XP, which is a desktop operating system.

Another area where Linux beats Windows hands-down is control. With Linux, bug fixes and upgrades are much more available, which results in a more stable OS. With Windows, you are at the control of your Microsoft masters.

One's actual software migration from Windows to Linux or Unix depends on a lot of things. Is your code proprietary or is written in Java? How many folks use the database concurrently, and how many different offices need to access to the system. What compilers are available for your language? These answers dictate a lot, and will define whether or not a new back-end infrastructure might need to be built to support your migration. What's the SLA for your application? Does it require high-availability? Generally, you are not going to be able to do this yourself, so be prepared to enlist the services of a top-notch systems integrator that will help you with the process. You may want to reach out to some of the Linux variants (I.E. Red Hat) to help you with this. Red Hat has is ready, willing and able to help you: http://www.redhat.com/services/consulting/

This was first published in December 2003