[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Traffic Monitor

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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

831 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