we are running Profile on Interbase,
we have one server which is for the database, now 2 servers that are
dishing out the TS connections and running Profile application. this is
where the slow bit is. The site where the servers sit are connecting
directly to the database server, running profile as an app on their
workstations.
we have another server that does our intranet and houses the ecg/stress
test databse, another for running the back office financial software,
one that does a PACs type role and our oldest server is essentially mine
and it runs MSSQL and I have the latest version of Profile on it to test
it for a month or two before letting it loose on the troops
it is slower currently at TS remote sites, but still sluggish at primary
site, and the TS server has high resource usage,
Duncan
Andrew wrote:
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
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
