Solved

Traffic Monitor

Posted on 2011-03-18
5
379 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

830 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