Bruce
bbruen at unwired.com.au
Tue Nov 18 00:55:28 CST 2008
What Stuart said and even more to allow the VM some elbow room. Secondly is it really VMWare? I didn't thimk there was a linux version. I have found that one weak area for VM environments on linux (and I've used a few) is the networking passthrough. It takes some fine tweaking to get the networking passtthroughs tuned properly. Finally, why SQLServer? Surely youd get better performance from postgresQL or (shudder) MySQL. In fact I've usually found postgreQL server faster than SQLServer on raw platforms. hth Bruce On Tuesday 18 November 2008 11:58:25 Stuart McLachlan wrote: > First thing I'd look at is the amount of memory you have allocated for your > VM. > > Running SQL Server on Windows Server, you'll need at least a couple of Gigs > of memory dedicated to it. > > On 18 Nov 2008 at 11:31, Darren D wrote: > > Hi All > > > > Please forgive the WAY OT Post but I need access to the Brains trust and > > I know a lot of you are SQL/VMWare gurus > > > > As this is a way OT post - feel free to respond to me off line to: darren > > at activebilling dot com dot au > > > > Moderators feel free to tell me to take it away > > > > > > > > We have a Dell server running Linux as the OS (Running Ubuntu I think) > > > > On this Linux server we have a VM Session running Windows Server as the > > OS > > > > On this VM Session we have our instance of SQL Server 2005 - And it is > > running like a slug. > > > > > > > > For instance - We copied a live and running SQL 2000 dB onto this SQL > > 2005 setup and started running comparisons against each on a large table > > and the results were awful. > > > > We started connecting our app to it as well and the results were even > > worse (About 12 minutes to open a relatively simple screen) > > > > Whereas the same app connected to the live and running SQL 2000 version > > runs as expected > > > > > > > > Can anyone advise if this multi layer OS/VM Setup is the likely culprit > > for the go slow? > > > > Does anyone know of sure fire things to change and even some things to > > try or gotchas? > > > > Also do we know of any analyser tools that we could test the Linux/VM > > Session config to see if that level is the culprit before we dig into the > > SQL 2005 setup? > > > > And anything else you can recommend > > > > > > > > Many many questions - > > > > > > > > Thanks heaps in advance team - Apologies again for the OT :-) > > > > > > > > DD > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com