Server very slow!!!

Question

I have a windows 2003 running with ColdFusion 8, Just updated to the latest hot fix today and JRE 6.0.15

Here is a description of the problem.
The website is running very fast, and when I look at the performance on windows it only uses 1% of the processor and memory...(We get about 2,000 hits per day on the website). I noticed that after a couple of day (2 or 3).

The server is very, very slow... when I look at the performance it show that it's using 98% of processing, at the same time when I look at the database server I see that all the MySQL connections are there and they do not disconnect... so if I restart the CF8 services, and clear all the connection the website goes back to normal.

I do NOT have the Maintain Connections checked on the data sources, so they should disconnect.

What could i do so this doesn;t happen in the server? Should I update the CF8 server? maybe cluster, or move the DB to MS SQL?

Thanks for the help..

About the machine... it's a dell with 2 xeon 3.0GHz with 4GB of memory and about 1TB Harddrive

Adam Cameron. · Answer

I'd get something like FusionReactor - or even just the built-in diagnostics in CF8 I guess (never used 'em) - and have a look if any threads are hanging, or if there's any weird JDBC activity.

2000 hits per day is a pretty quiet site, so all your kit (H/W & S/W) should handle it just fine, and definitely no need to cluster anything (well: not for traffic considerations, anyhow... fault tolerance is another thing). With 2000 hits a minute you might want to look @ that sort of thing, but not 2000 hits a day.

Is there anything interesting in your CF or JRun logs?

Have you got a request timeout set in CFAdmin?

How much RAM are you allocating to your JVM? How many simultaneous template requests & JRun threads have you got set? Got any possibly runaway scheduled tasks running, or anything like that?

It might be an idea to use your onRequestStart & onRequestEnd handlers to the start and finish time of each request, to give you an easy way of spotting any requests that never finish, or any that take longer than a few seconds. Once threads start getting chewed up by slow requests, it doesn't take mjuch for that to snowball into a non-responsive server.

--

Adam

General Settings
Timeout requests	Yes
Enable Per App Settings	Yes
Request Time Limit	360 seconds
Use UUID for CFToken	No
Enable Whitespace Management	Yes
Disable Service Factory	No
Protect serialized JSON	No
Protect Serialized JSON Prefix	//
Missing Template Handler
Site-wide Error Handler
Enable HTTP status codes	Yes
Enable Global Script Protection	Yes
Default CFForm ScriptSrc Directory	/CFIDE/scripts/
Maximum size of post data	500 MB
Request Throttle Threshold	2 MB
Request Throttle Memory	200 MB
Request Tuning
Simultaneous request limit	50
CFThread Pool Size	10
Maximum number of report threads	1
Maximum number of running JRun threads	50
Maximum number of queued JRun threads	1000
Caching
Template cache size	1024 templates
Enable trusted cache	No
Cached query limit	100
Save Class Files	Yes
Cache web server paths	No
Client Variable Settings
Default client variable store	Cookie
Purge Interval	1 hours 7 minutes
Client Stores
Cookie
Type	COOKIE
Description	Client based text file.
Purge data after time limit	Yes
Time limit	10 days
Disable global updates	No
Registry
Type	REGISTRY
Description	System registry.
Purge data after time limit	Yes
Time limit	90 days
Disable global updates	No
Memory Variables
J2EE Sessions	No
Application Variables
Enable Application Variables	Yes
Default Timeout	2,0,0,0
Maximum Timeout	2,0,0,0
Session Variables
Enable session variables	Yes
Default Timeout	0,0,20,0
Maximum Timeout	2,0,0,0

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded