Performance differences between Windows and Linux-based databases

Get help making an apples-to-apples comparison of database performance in Windows vs. Linux systems. Performance and Tuning expert Jeremy Kadlec gives you several factors to consider.

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
  • Manageability
  • Scalability
  • Reliability
  • Fault tolerance
  • Third party support

Good luck and choose wisely!

Do you have comments on this Ask the Expert Q&A? Let us know.

Next Steps

SQL Server for Linux illustrates how Microsoft is evolving

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning