Solved

Traffic Monitor

Posted on 2011-03-18
5
375 Views
Last Modified: 2012-08-14
We are a pharmacy that runs a pervasive database in order to track and store prescriptions.  Once or twice per day about 60-75% of our computers lose connection with the pervasive database and we receive strange errors.  It is all happening at the same time.  The company that supports the front end program believes there is some kind of excessive network traffice situation that causes database issues.  Is there a program that would allow me to track something like this?  The pervasive database is on a windows 2003 server and I don't see anything strange in the event logs.  I would be open to turning more logging on if I knew what to turn on.  Any ideas on how to monitor what might be causing what seems to be network latency?

Thanks.
Joe
0
Comment
Question by:joemckamey
5 Comments
 
LVL 35

Expert Comment

by:Ernie Beek
ID: 35169336
There are lots of tools out there. A good overview is found at: http://www.experts-exchange.com/Software/System_Utilities/Q_26748566.html?cid=748#a34841205 I'm sure there is something you can use over there.
0
 
LVL 1

Accepted Solution

by:
Field Marshall Bob earned 500 total points
ID: 35169345
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 35169882
You said you didn't see anything in the event logs.  How about the PVSW.LOG files on both the server and one of the clients getting the errors?  What are the Pervasive errors being seen?

You said that it's happening at the same time, do you mean it happens at the same time of the day?  If so, is there some process or event that's happening at that time?  

What version of PSQL are you using?  Is Pervasive Auto Reconnect enabled on both the clients and server?  

Wireshark is a good idea for tracking what's happening on the network.  
0
 
LVL 9

Expert Comment

by:Red-King
ID: 35188532
If you can set up a unix server then you could also consider using cacti to graph traffic.
0
 
LVL 9

Expert Comment

by:Red-King
ID: 35188545
You might want to also look at using Performance Monitor on the 2003 server. There's a load of differrent counters you can use for monitoring different aspects of the server.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now