?
Solved

Traffic Monitor

Posted on 2011-03-18
5
Medium Priority
?
393 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

777 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