100% cpu

[belgiumbruno]

Hi all,

we are using fmserver with windows 2000 terminal services.

So fmserver on dedicated win2k server machine (works fine) and everyone

enters the data via fmpro on the terminal server.

The problem I have is on this ts machine. fmpro takes sometimes 100% of the cpu (and not only when difficult things are done)

server specs : raid 5 - 1024meg ram - 600mhz processor

How to avoid ??

Thanx,

Bruno

[Kurt Knippel]

FM Server and Win2k Terminal Server are SEPERATE machines? Make sure that they are 2 distinct machines.

The only real thing that I see is that 1024MB RAM is wwwwwwaaaaayyyyyy to much for FM Server. Filemaker serves DBs from disk and not RAM, so all that extra RAM (beyond perhaps 256MB) is all wasted and just requires extra processing to manage.

The RAID is good.

[Anatoli]

What are the specs for Windows Terminal Services machine?

[belgiumbruno]

the terminal server machine is a compaq proliant -win2k server - intel pentium III 600mhz - 1024ram - raid5 hd 9.1gb .

fmpro is installed on it . the fmserver is -like fm wants it - on a seperate

machine. All the clients enter the db via ts (

[Will]

Your hardware should be sufficent. I assume you know FileMaker Pro is the problem because you are looking under Task Manager and seeing FileMaker is running at 100%, right? What version of FileMaker Pro is it? Have you applied any updaters for your version of FileMaker Pro? Is this a recent problem on the server or has it always occured?

[belgiumbruno]

Hi,

No my problem is that I wanted to know if it is a known problem

for fm. On the clientside you can't do anything wrong. Put fmpro on the pc,

click host to go to the fmserver and there you are.

So if my cpu goes to 100% it must be a hardwareproblem or a common problem in fm. That's why I mentioned dos-programs on a win2k terminalserver. It's a well known problem that it takes all the cpu to run.

tought that fm had the same sickness.

Are there any settings you can change on clientside ??

thanx,

Bruno

[Anatoli]

On our good HW FM server is around 5-20% with heavy hits from 80 users.

Today my machine (client) was at 100% CPU when opening FM files and it was slow. The problem was in network wiring.

Terminal services, email and PC anywhere worked as in other day.

Only Panda antivirus and FileMaker, both heavy network applications had problem.

After switching to another segment everything was back to normal.

[belgiumbruno]

Hi,

so that's intresting. a bad wire can cause 100% of cpu ?

How can you explain that ?

But how can I increase the network kb?

The rest looks good.

Bruno

[Will]

Bruno -

I guess I'm a little confused. Please clarify.

Where is FileMaker Pro running - on each client PC or installed on a Terminal Server?

Where is FileMaker Server running - on a Windows 2000 Server or a Windows 2000 Server running Terminal Services?

Thanks.

[Anatoli]

When packets are checked for TCP/IP checksum, the corrupted are rejected.

Normally it is one in thousands or millions.

With bad wire or bad network card there is one good packet in thousands. The machine is asking for resend as mad to assemble bits and pieces.

Good test is file copying.

If small files are getting through and large ones are stuck or timeout, there is problem on network.

HTH

[belgiumbruno]

Will,

1 terminal server win2k machine where everyone uses filemaker pro 6.0

with the host button to another dedicated win2k server machine with fm server to the db. Everything works fine except that sometimes the cpu=100%

(it's fm because i checked taskmanager).

I am now bussy for more than a year with fm.

It's a great program to design difficult db but I have no experience

with the limitations. So I constantly have to change some things in the programming.

Ex. I am bussy with a stockmanagment system.

the total in stock is a calc. field (stock purchase-stock sold).

In the beginning I put this field simply on the layout. You could see immediately what was in stock. The problem was that I constantly have to search on this field. Finding on a calc. field takes minutes so I had to script

the calculation. Now it's a normal indexed number field with a fantastic searc speed. Now I begin to understand all the people in this forum who do scripting during the night. They let the scripts calculate all these kind of fields.

With this small example I will tell that I understand the working of fm but I still have to find it's negative points. I think that I will know all the bottlenecks of fm within 6 months when everyone in the company uses it.

thanks,

Bruno

[Anatoli]

RE: the total in stock is a calc. field (stock purchase-stock sold).

NEVER EVER DO THAT. Only if you expect small number of records.

Do transaction system, where total stock is static figure. Not calc.

The details about the transaction are in separate file.

Opening stock = 100 pc

received 100 pc = stock 200 pc

sold 150 pc = stock 50 pc.

That will be fast and without the nightly scripting.