On Tue, Sep 08, 2009 at 02:04:35PM -0400, Ross Walker wrote: > On Tue, Sep 8, 2009 at 1:57 PM, Pasi Kärkkäinen<pasik at iki.fi> wrote: > > On Tue, Sep 08, 2009 at 10:22:56AM -0700, John R Pierce wrote: > >> Rob Kampen wrote: > >> > One of my clients use a software product that is "upgrading" and will > >> > shortly utilize micro$oft SQL server 2005. > >> > Currently the clients are XP on older machines with the database > >> > residing on a Samba / CentOS server and this works very well. > >> > Question: Does anyone run SQL server from XP in a virtualbox on CentOS? > >> > Any other configuration that works on a linux server? > >> > I do not want to have to buy another server grade machine just for > >> > this application. > >> > >> 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. > >> > >> SQL Server has fairly expensive licensing per user too. > >> > >> 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. > >> > > > > I've been running various MSSQL databases on VMware VMs without problems.. > > of course you need to have fast enough disks (or a SAN). > > > > Also I've been running Oracle, Mysql and PostgreSQL databases on > > Xen virtual machines for years without problems. > > > > It all depends on your CPU and/or IO requirements.. if you need all the > > possible resources, then virtualization is not a good thing. > > Actually $$$ can overcome that. > > I know serveral high transaction SQL implementations running off of > ESX going to either FC 3Par or EMC systems. > Yeah and I know some such setups using Equallogic iSCSI storage :) > But I don't think the OP's requirements are at that level by the sound > of things. > Yep. -- Pasi