[CentOS] SQL Server 2005 and CentOS?

Joseph L. Casale JCasale at activenetwerx.com
Tue Sep 8 18:20:26 UTC 2009


>SQL Server only runs on Windows SERVER OS's.  on a desktop OS like XP,
>youc an only run the 'lite' version aka MSDE or SQL Express depending on
>which version, and this only allows a very few database connections, and
>is mostly suited for standalone single user applications and software
>development.

Uhm, no. Check the Support matrix:
http://technet.microsoft.com/en-ca/library/ms143506%28SQL.90%29.aspx

>I would NOT virtualize a SQL database server, they have intensive disk
>IO I/O requirements.  also don't run a database on a network mounted
>file system (samba, NAS, etc) for the same reason.

Uhm, no again. SQL doesn't have intensive disk IO, *some* usage patterns create
intensive disk IO. And it works very well, hell, there are many virtual environments
that emulate hardware with more horsepower than *most* baremetal. Your saying
a 32 way server with 256G of ram infront of a 4G FC san with rows of SAS discs
isn't better that a little POS HP DL380G5? I think not...



More information about the CentOS mailing list