Network Sniffers

[wc2]

I would say itw more likely to be a database configuration issue or a Windows performance issue. Start up perfmon and monitor thinks like the disk IOPS, the SQL Latches and query responses. Is your SQL database put on the right RAID levels on the SAN?

Can you install the client on the server and run the same tests from that client to negate any affect the network might be having?

The Database for Job Costing is MS Access - I have no idea what flavour Line 50 is. Although I know it's not SQL.

[JoJoGabor]

I would say itw more likely to be a database configuration issue or a Windows performance issue. Start up perfmon and monitor thinks like the disk IOPS, the SQL Latches and query responses. Is your SQL database put on the right RAID levels on the SAN?

Can you install the client on the server and run the same tests from that client to negate any affect the network might be having?

[wc2]

Have you seen this yet?
http://www.sbslimited.co.uk/sageslow.htm

It suggests a large number of potential solutions for sage performance problems..

Yes, I've found the very site..

Going to give some of the things a try.

Cheers

[Paddy]

I have found one of the most useful tools is the old original Sniffer Pro. It needs to grab info from the lower ISO layers so modern OS will not work. My work-around is to run NT4 on VM on my laptop. Sniffer then works fine and picks up a lot of info.

(An alternative would be put NT4 and Sniffer on a bootable USB stick)

[TheRefactornator]

Have you seen this yet?
http://www.sbslimited.co.uk/sageslow.htm

It suggests a large number of potential solutions for sage performance problems..

[wc2]

Yes, Found Wireshark (Thanks Guys) All seems to be fine on their network, Although No one is using their system today.

So new question is...

How do you speed up/Give more resource to a Job Costing database (MSA - mdb's) - Windows 2000 Server?

Cheers

[pmeswani]

I've always found Ethereal very good...

Which is now called Wireshark.

The problem could be application / server related rather than network related.

[EqualOpportunities]

Anyone know of any network type sniffing software tools?

I've got a client network that runs Sage Line 50 & Sage Job costing really slowly. 9 users running job costing.

It's not antivirus causing it. (excluded all file extensions & directories on both server and clients)

Both line 50 and Job Costings have a dedicated server with a gigabit NIC. Network runs over a Netgear gigabit switch. PC's are high specs with gigabit NIC's

All ping responses to everything are <1ms

The Server is never under stress (sits at about 98% idle.)

Cheers

I've always found Ethereal very good...

[wc2]

Anyone know of any network type sniffing software tools?

I've got a client network that runs Sage Line 50 & Sage Job costing really slowly. 9 users running job costing.

It's not antivirus causing it. (excluded all file extensions & directories on both server and clients)

Both line 50 and Job Costings have a dedicated server with a gigabit NIC. Network runs over a Netgear gigabit switch. PC's are high specs with gigabit NIC's

All ping responses to everything are <1ms

The Server is never under stress (sits at about 98% idle.)

Cheers