Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Traffic Monitor

Posted on 2011-03-18
5
Medium Priority
?
398 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

Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

Question has a verified solution.

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

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

618 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