I thought Duncan was running Profile, and therefore not using MSSQL but Interbase ?
Is it slow at the primary site as well as the remote sites ? Andrew.C From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Machell Sent: Saturday, 16 June 2007 9:22 PM To: General Practice Computing Group Talk Subject: Re: [GPCG_TALK] virtual servers On 16/06/2007, at 8:09 AM, Duncan Guy wrote: We have over 40 Drs, 7 sites all relying on an inhouse EMR. Our IT guru threw another server at the situation and using Microsoft load balancing slowed it all down even further, In total we have 7 servers doing different jobs, would be good to get them all working on the same team or outsource it totally, Duncan, I agree with Tim that you should get a proven professional opinion. I assume all your clients are TS so you don't have a client / server bottleneck, that your "guru" has half a brain and is throwing fibre channel at your server network and everything he can at your I/O, I'd say you have hit the limits of what MSSQL can do. Perhaps it's time to investigate Oracle on Unix, although I'd hate to imagine what you've already paid Bill. Find yourself a really good DBA. You could probably justify a half-time job for one. cheers, Peter.
_______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
