Performance differences between Windows and Linux-based databases
Are there performance differences among SQL Server databases for Windows 2000, Windows NT and Linux systems?
SQL Server operates only on Windows, so a comparison to Linux systems would have to be at a database level. I would determine which database you are going operate on the Linux system and try to make an 'apples-to-apples' comparison based on the following:
- Hardware costs
- Software costs
- IT expertise
- Support costs
- Maintenance costs
- Vendor support
- Ease of use
- Fault tolerance
- Third party support
Good luck and choose wisely!
Do you have comments on this Ask the Expert Q&A? Let us know.
This was first published in September 2005