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