Performance problem (OpenInsight 32-Bit)
At 16 MAR 2009 12:17:39PM Bob Silverstein wrote:
I am running OI 8.0.6 on a tiny network (2000 server, six XP sp3 work stations). About a month ago, the performance died. Records opened very slowly in forms, navigating from one to another control was painfully long. I do not think OI ever locked up but sometimes we would just kill it out of impatience.
I rebuilt the three critical and largest files and watch them to make sure they do not have too many overflow frames. Changed the network driver from 3 back to 2.1 without any improvement.
We do not have any problems with our networked applications or data. Have not installed any new programs. In fact, I removed Windows Defender. I set anti-virus software, Sophos, not to scan the ov or lk files. Virus definitions are current. Spybot finds nothing. Could this be due to a Windows update?
Any ideas?
At 16 MAR 2009 12:40PM John Bouley wrote:
Are there other applications noticing a slowdown?
You could have a problem with a network switch…Have you check the network for broadcast traffic?
HTH,
John
At 16 MAR 2009 02:00PM Bob Silverstein wrote:
Good questions, John.
No problems with any other application. If I run OI on a stand-alone machine, no problems. Network traffic rarely goes above 2%. Plenty of RAM in all machines. I hibernate the server every night. Rebooting does not help. I turn off the modem, router and switch every night so they are fresh the next morning.
The problem seems limited to networked OI and probably more likely software than hardware.
At 16 MAR 2009 03:14PM Mike Ruane wrote:
Bob-
Are there any OE*.log files, or other log files that could be from OI?
Mike
At 16 MAR 2009 05:24PM Bob Silverstein wrote:
Mike, no log files at all in the OI application directory.
At 16 MAR 2009 05:55PM Bob Silverstein wrote:
Mike, two things just happened on separate machines.
1.) Got the send to Microsoft Windows error message. Hit the wrong button and sent it to MS before I could save it. I could not find the message anywhere. Do you know where it might be hiding?
2.) OI froze up with about 80% utilitzation beshown in task manager. Had to terminate the OI.exe process which was being reported as non-responsive.
At 16 MAR 2009 06:23PM Barry Stevens wrote:
Have a look in the MS event viewer (Control Panel-]Admin Tools) - applications (I think)
At 17 MAR 2009 12:19PM Jared Bratu wrote:
Try this this step during peak hours. On the server console, if you right click "My Computer -] Manage" and look at the "Shared Folders -] Open Files" list do you see any .lk or .ov files listed?
Do you run any instances of OI on the server console or through a terminal server session?
At 17 MAR 2009 01:49PM Bob Silverstein wrote:
Jered, I see plenty of lk and ov files plus a whole slew of OI program files. The workstations access OI on the server.
I rebuilt the three main indices and the performance is better. Could that be an issue?
At 17 MAR 2009 01:51PM Bob Silverstein wrote:
Barry, nothing suspicious in the event viewer.
At 17 MAR 2009 02:07PM John Bouley wrote:
Are you using a service? I think the reason Jared asked the question was there isn't supposed to be any lk or ov files open at the server if you are using a service.
If you are not using a service then you are risking data corruption and slow performance…
John
At 18 MAR 2009 08:45AM Bob Silverstein wrote:
I am not using a service.
However, I think I may have found the solution. I rebuilt the three key indices and have not had the problem since then. I do not understand why the data and dictionary files are so immune to corruption while the bang files are. About the only problem I have had thru the years has been with the indices. Data and dict's just do not seem to go bad but the indices are very finicky. And they do so without warning.
I guess this is a Mike question.
At 18 MAR 2009 09:50AM John Bouley wrote:
Bob,
Your problem along with preventing GFE's was what the network products were designed to address. In the future, I would seriously consider using them.
Yes indexes have always been more vulnerable to corruption but that does not mean the data tables are immune. A power glitch at the wrong time can easily corrupt a data file. Its just that indexes are touched much more often than data tables. While the network products "virtually" eliminate data corruption (GFE's) they do not totally eliminate the need for indexes to be rebuilt. Unfortunately, this is a side-effect of how the whole indexing architecture is designed… but that is another topic…
just my two cents.
John
At 18 MAR 2009 01:24PM Jared Bratu wrote:
Bob, John is exactly right regarding indexes and the open files. Only the Universal Driver should be accessing the .lk/.ov files. Because the service runs on the server as a local user there shouldn't be any .lk/.ov files open.