CF8 - WinServer2003 - IIS

[Guest]

I about 5 dozen CF applications, and growing, on a single server that is accessed by about 400 local users. There are times when the response is very slow and today was one of those days that required 3 reboots of the server; the IIS was functioning but CF was under the crunch. I have been arguing with our IT support group for a cluster web server with a load balancer but my requests are falling on deaf ears.

The servers are HP pizza boxes with dual G NIC ports, 3G RAM, dual Xenon's. Does anyone have experience with Win Server 2003, IIS and CF7 or CF8?

We still use MS Access.

[Newsgroup_User]

most likely it is your ms access db that is at fault here...
even with 5 simultaneous users it will be slow, never mind 400...

you can use SeeFusion or FusionReactor to monitor your server's activity
and pinpoint the bottleneck. you can use built-in cf monitor if you are
on Enterprise, too.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Guest]

Thanks. I have been resisting MS SQL but maybe I have to bite the bullet.

[tclaremont]

Upsizing an Access database to SQL is relatively painless. You can probably get by with the free Express edition, too.

The difference will be night and day.