Recent content by UKStratfordMike

Trist123 & Tom Thanks for your help Mike:)

Receiving error message in log from an app vendor's package (hundreds of modules). Error message as useful as a chocolate teapot from a diagnostic point of view. App vendor similar - Problem logged in March but no joy. So...trying another way. Want to find the module responsible so can...

Hi Can anyone provide e.g sql code to access Progress Systems tables (via ODBC) :confused:

Background - Monitoring vst by our expert highlighted one table with 1.8 Bn (US) requests in 1 hour. Request/actual DB read ratio around 161k:1 App vendor had been investigating, 'added some indexes to a table' something about a trigger and throughput increased 30 (yes 30) fold. Offending table...

Thanks guys I was of same view - poor code and increase to 100k to get out of problem short term. I'm an out of retirement oldie from V7 days so my street cred this supplier lower than a snakes belly. Great to get conf that I'm not losing the plot! Casper - IMO?

Site: New Dell Server 16 procs, SAN, Windows and Vmware. Progress V9.1D (sorry!) with 4 dedicated procs, 4Gb physical memory (6Gb virtual) Software house app running core business – c. 100 on line users. Also have up to 5 users who can fire bulk data/updates into app (using vendor programs)...

See what you mean re short intervals Promon. It was checkpointing.

Hi Tom Thanks for prompt response. Will need to get the params to you tomorrow. I am 150 miles away from client site and may need to get them from supplier - we do have some R&D stats from Promon though. Re triggers in data dictionary, sorry but my lack of knowledge immedately exposed...

My background : Progress V8 (and before)/ Unix. Some DBA knowledge. Ancient IT guy brought out of (happy) retirement to help a company with performance problems with new app. Being told all sorts of conflicting things by suppliers. Site : New Dell Server 16 procs (4 dedicated to Progress...