WARNING - OLD ARCHIVES

This is an archived copy of the Xen.org mailing list, which we have preserved to ensure that existing links to archives are not broken. The live archive, which contains the latest emails, can be found at http://lists.xen.org/
   
 
 
Xen 
 
Home Products Support Community News
 
   
 

xen-users

RE: [Xen-users] MSSQL and Xen performance

To: "xen-users@xxxxxxxxxxxxxxxxxxx" <xen-users@xxxxxxxxxxxxxxxxxxx>
Subject: RE: [Xen-users] MSSQL and Xen performance
From: Nathan Eisenberg <nathan@xxxxxxxxxxxxxxxx>
Date: Fri, 8 May 2009 09:22:26 -0700
Accept-language: en-US
Acceptlanguage: en-US
Delivery-date: Fri, 08 May 2009 09:23:29 -0700
Envelope-to: www-data@xxxxxxxxxxxxxxxxxxx
In-reply-to: <23448294.post@xxxxxxxxxxxxxxx>
List-help: <mailto:xen-users-request@lists.xensource.com?subject=help>
List-id: Xen user discussion <xen-users.lists.xensource.com>
List-post: <mailto:xen-users@lists.xensource.com>
List-subscribe: <http://lists.xensource.com/mailman/listinfo/xen-users>, <mailto:xen-users-request@lists.xensource.com?subject=subscribe>
List-unsubscribe: <http://lists.xensource.com/mailman/listinfo/xen-users>, <mailto:xen-users-request@lists.xensource.com?subject=unsubscribe>
References: <8478A0C7-100A-4B38-B5FC-D58809504F90@xxxxxxxxxxxxxxxxxx> <7207d96f0905071849j24a101dv5f4ad7f3f5b3c17e@xxxxxxxxxxxxxx> <002e01c9cfe4$794a10c0$6bde3240$@Henning@prd-inc.com> <23448294.post@xxxxxxxxxxxxxxx>
Sender: xen-users-bounces@xxxxxxxxxxxxxxxxxxx
Thread-index: AcnP9DZlJXfBZqzkRSWcnR2B/u7L9QABMw+g
Thread-topic: [Xen-users] MSSQL and Xen performance
Damn you, Centos, for your old repository versions.  I'd highly recommend 
looking at a newer version of XEN than 3.1 - there have been some major 
performance gains since then.

Best Regards
Nathan Eisenberg
Sr. Systems Administrator
Atlas Networks, LLC
support@xxxxxxxxxxxxxxxx
http://support.atlasnetworks.us/portal


-----Original Message-----
From: xen-users-bounces@xxxxxxxxxxxxxxxxxxx 
[mailto:xen-users-bounces@xxxxxxxxxxxxxxxxxxx] On Behalf Of blackc2004
Sent: Friday, May 08, 2009 8:47 AM
To: xen-users@xxxxxxxxxxxxxxxxxxx
Subject: RE: [Xen-users] MSSQL and Xen performance


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

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

The storage backend is via iSCSI to an Equallogic PS5000.

Since this is a brand new MSSQL installation (and we have never had one
before), I do not know what the load will look like for us.

I have been noticing some network performance issues in early testing and
will be implementing some changes to the severs this weekend to see if those
are resolved. I will also be looking into the GPLPV which have been
suggested!

Thanks again


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.  Regardless, some testing of your scenario options would be duly
> diligent.
>       Dustin
> 

-- 
View this message in context: 
http://www.nabble.com/MSSQL-and-Xen-performance-tp23435695p23448294.html
Sent from the Xen - User mailing list archive at Nabble.com.


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





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