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