Hello all.
I'm new to this forum. I've been supporting a customer that has a product by Sage Software called Intergy EHR.
It uses a Progress database (OpenEdge 10.1B).
I know little to nothing about progress - leaning towards nothing. Sadly my experience is more with SQL/MySQL and Oracle.
I'm supporting this client's network, servers and telephone systems.
They are distributed over several locations in the South West United States.
The progress database is running on a dual socket, dual core Intel server with 2.0G cores, 13GB of RAM and 3 mirrored sets of disk.
Yep - you heard right - they've got six physical disks (15k rpm drives) and chose to setup 3 mirrors. I'm not sure that makes ANY sense at all but i would have thought if you're going to mirror - do a raid 10 so you get the extra spindles shared.
Its running windows because they put the server up originally as thier domain controller as well so it's running some other infrastructure services like DHCP, DNS and Active Directory.
They use two separate terminal servers to present the apps to the employees. These two servers run Intergy EHR which connects to the database.
I'm seeing a HUGE number of processes taking on average of 500mb+ of memory and this adds up to WAY more than the 13GB in the server. However the server shows 6GB free of memory with 6GB used of pagefile space. I'm also showing two 13GB swap files on the C: and D: drives.
I'm not seeing too high of a disk queue on the server - but I'm thinking maybe its masked because it's coming in the form of heavy paging to the disk because of memory shortage.
I may be WAY WAY off base here, but not knowing Progress and how it works and what to look for, I'm really really struggling.
Can any one offer me any direction?
The performance issues I'm seeing seem to point to the Database and I'm thinking IO issues.
Thanks in advance - I'm standing by and prepared to answer all questions you may have about the environment to help paint a picture for you. Please include Progress specific instructions to collect information that you may request - I have no idea how to even get to an SQL type CLI to query information you may request.
Thanks thanks thanks!!
PS - See attachment for process list. Its from Process Monitor so it's got LOTS of good info. Turn off your word wrap or it will be UGLY.
Humbly yours.....
John
I'm new to this forum. I've been supporting a customer that has a product by Sage Software called Intergy EHR.
It uses a Progress database (OpenEdge 10.1B).
I know little to nothing about progress - leaning towards nothing. Sadly my experience is more with SQL/MySQL and Oracle.
I'm supporting this client's network, servers and telephone systems.
They are distributed over several locations in the South West United States.
The progress database is running on a dual socket, dual core Intel server with 2.0G cores, 13GB of RAM and 3 mirrored sets of disk.
Yep - you heard right - they've got six physical disks (15k rpm drives) and chose to setup 3 mirrors. I'm not sure that makes ANY sense at all but i would have thought if you're going to mirror - do a raid 10 so you get the extra spindles shared.
Its running windows because they put the server up originally as thier domain controller as well so it's running some other infrastructure services like DHCP, DNS and Active Directory.
They use two separate terminal servers to present the apps to the employees. These two servers run Intergy EHR which connects to the database.
I'm seeing a HUGE number of processes taking on average of 500mb+ of memory and this adds up to WAY more than the 13GB in the server. However the server shows 6GB free of memory with 6GB used of pagefile space. I'm also showing two 13GB swap files on the C: and D: drives.
I'm not seeing too high of a disk queue on the server - but I'm thinking maybe its masked because it's coming in the form of heavy paging to the disk because of memory shortage.
I may be WAY WAY off base here, but not knowing Progress and how it works and what to look for, I'm really really struggling.
Can any one offer me any direction?
The performance issues I'm seeing seem to point to the Database and I'm thinking IO issues.
Thanks in advance - I'm standing by and prepared to answer all questions you may have about the environment to help paint a picture for you. Please include Progress specific instructions to collect information that you may request - I have no idea how to even get to an SQL type CLI to query information you may request.
Thanks thanks thanks!!
PS - See attachment for process list. Its from Process Monitor so it's got LOTS of good info. Turn off your word wrap or it will be UGLY.
Humbly yours.....
John