SID-00110: Performance Issue on Windows 2003 Server

Status:	Answered	TWiki version:	4.2.4	Perl version:	5.8.8
Category:	CategoryPerformance	Server OS:	Windows 2003 Server	Last update:	17 years ago

Im running TWiki 4.2.4 with ActiveState Perl 5.8.8 and Apache 2.2.11 on an Windows Server 2003 based machine.

TWiki works great except the speed which bothers the users a lot !

Each time when an twiki page is been opened, the perl.exe file spikes up my CPU usuage to 100% in turn the twiki page opens very slowly (an normal page without any plugins takes 10 to 15 secs to open up)

Is there any caching technique that can be implemented on an Windows 2003 server machine or am I missing something that causes this problem ?

-- RajeshN - 17 Feb 2009

Discussion and Answer

Hmm, not sure what is wrong. With recent hardware, a page access should not take more than 1 sec. I do not have experience with Windows install, may be someone else can help.

-- PeterThoeny - 17 Feb 2009

It is an Dell Power Edge 1850 Windows Server 2003 R2 Pentium D 3.0 GHz 3 GB RAM 2x 160 GB SATA 7200 RPM disks – no RAID.

-- RajeshN - 17 Feb 2009

I have a similar set-up on Windows Server and pages load in a couple of seconds (and I have a lot of plugins in use). It even works OK on a Windows XP work station.

There is a caching plugin, but I prefer to have "live" content whenever possible. It can help, but it shouldn't be mandatory.

One thing I found is that performance takes a big hit if you try to use a remote file share: TWiki has to load many different files to generate a page, and so network latency becomes an issue. Are your /bin and /pub directories local to the Apache server (e.g., a drive letter)? Or are they accessed from a remote location via a UNC name (e.g., \\share\twiki)?

-- SeanCMorgan - 17 Feb 2009

Hi Sean,

Both Apache and the twiki/pub and twiki/bin lies on the same server, but on different drives - Apache lies on the c:\ and the twiki files lies on the d: Could this cause a problem?

-- RajeshN - 18 Feb 2009

Check the logs and warns files in twiki/data for clues. In a w2003 server I would use a tool like Process Monitor to see what's going on in the file system.

-- EnriqueCadalso - 18 Feb 2009

I dont see anything odd under twiki access or error logs.

When I used Process monitor to see the list of process running when opening a twiki page, I see too many entried for ApacheMonitor.exe , jqs.exe (Java quick strart) and httpd.exe

Is this right?

-- RajeshN - 19 Feb 2009

In process monitor there is a view to see what file access are happening in sequential order. With this view open, open a page, then analyze the opened files. Filter the apache processes. There may be something that is requested and is not there. Performance issues generally are produced by an image referenced somewhere that does not exist in the referenced path, so it takes some timeout to the page to be rendered.

-- EnriqueCadalso - 19 Feb 2009

With your above answer's help I noticed something strange appearing always on my Apache access logs

 "GET /twiki/pub/TWiki/TWikiDocGraphics%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20/bubble.gif HTTP/1.1" 200 342  = "GET /twiki/pub/TWiki/TWikiDocGraphics%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20/searchtopic.gif HTTP/1.1" 200 580 = 







= "GET /twiki/pub/TWiki/TWikiDocGraphics%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20/index.gif HTTP/1.1" 200 100 = 

Im using the index.gif, searchtopic.gif and bubble.gif on the WebLeftBar
Can the above be the cause of the problem?

-- RajeshN - 19 Feb 2009

>Can the above be the cause of the problem?

Probably, as per Enrique's good idea. It's easy enough to find out: what happens if you remove them from WebLeftBar

Also, what is the raw text version of that part of your WebLeftBar? If you use something like %ICON{index}% you shouldn't have any problems.

-- SeanCMorgan - 19 Feb 2009

Remove the trailing spaces from the ICONTOPIC setting and all other settings in your Main.TWikiPreferences page or TWiki.TWikiPreferences page. My recommendation: Don't use the WYSIWYG editor to edit system pages, this editor is still too buggy.

-- PeterThoeny - 19 Feb 2009

Hi Sean,
Below is the content for my WebLeftBar

GENERAL 

• [[SFGeneralComments][%ICON{"bubble"}%Comments]] 

• [[%SCRIPTURLPATH{"view"}%/Support/WebCreateNewTopic?parent=SID-00110][ %ICON{"newtopic"}% Create New Topic]] 

• [[WebTopicList][ %ICON{"index"}% Index]] 

• [[%INCLUDINGWEB%.WebSearch][ %ICON{"searchtopic"}% Search]] 

• [[WebChanges][ %ICON{"changes"}% Changes]] 

• [[WebNotify][ %ICON{"notify"}% Notifications]] 

• [[WebRss][ %ICON{"feed"}% RSS Feed]] 

• [[WebStatistics][ %ICON{"statistics"}% Statistics]] 

• [[TWikiUsers][%ICON{"person"}%Users]] 

Hi Peter, What editor do you suggest as an alternative for WYSIWYG ?

-- RajeshN - 23 Feb 2009

On system pages, use the "raw edit" at the bottom.

-- PeterThoeny - 23 Feb 2009

Hi all,

When I removed the Trailing spaces in the ICONTOPIC setting, the above log stopped appearing and in turn my twiki speed has also improved a lot !!!

-- RajeshN - 23 Feb 2009

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.