Re: [Xen-users] MSSQL and Xen performance

["Fajar A. Nugraha" <fajar@xxxxxxxxx>]

On Fri, May 8, 2009 at 10:46 PM, blackc2004 <chrisb@xxxxxxxxxxxxxxxxxx> wrote:
>
> Thanks everyone for the tips!
>
> Unfortunately I didn't get to "pick" the consultants, they came with the
> company that is doing our new ERP installation. So far I have not been happy
> with the way things are going.
>
> I am running:
> Xen 3.1.2-128.1.6.el5
> CentOS 5.2
> PowerEdge 2970 (2) Quad Core Opteron 2344HE, 4x512K Cache 1.7GHz, 1Ghz
> HyperTransport

So you only have one server? And how do your consultant propose using
it, putting everything on one OS? Using other virtualization
technology?

This might sound silly, but is it possible that your consultant fee is
higher than the server price?

>
> I have given 5 VCPUs and 4 gigs of RAM to the MSSQL Server, I was planning
> on increasing that within the next week.

> Dustin Henning wrote:
>>
>> Another important note regarding using Windows on Xen:
>> I am pretty sure that using multiple CPUs causes severe performance loss
>> with the GPLPV drivers provided by James Harper (to the extent that having
>> one VCPU with the drivers may net better performance than having
>> multiple).
>> However, I believe the GPLPV drivers still provide better performance with
>> multiple vcpus than not having the drivers would.  This information could
>> be
>> slightly dated, but I believe it was recently mentioned by someone else on
>> the list.

Probably me :)
http://lists.xensource.com/archives/html/xen-users/2009-05/msg00185.html

Last performance testing I did was on 0.9.12-pre13. It is possible
that the latest version perform better, so you should definitely do
your own testing to find out what works best.

Regards,

Fajar

_______________________________________________
Xen-users mailing list
Xen-users@xxxxxxxxxxxxxxxxxxx
http://lists.xensource.com/xen-users