Hello,
Let me start by saying that I am not experiencing any serious performance issues with my Progress (10.2A SP1 hot fix 2) database, so this may not be an issue at all.
We recently moved our database from Windows 2003 to 2012. Within a day of going live on the new server, I noticed that the memory utilization (using task manager) stays around 98 to 99% of 32 GB. It stays there until I stop the database and then it drops to around 10 or 15%. After rebooting the server and starting the database it starts out around 18% and then sometime later (usually overnight) after a few users have logged in, it is back up to 99%. Over the weekend, I added another 16 GB of physical memory and by Monday afternoon it was back to 99% with only 3 users logged in (Labor Day).
Like, I said, no performance issues to mention, except after running for about 5 weeks without restarting, we began having slow performance with WebSpeed processes. After restarting the server, the WebSpeed performance was back to normal. I plan to restart the server every couple of weeks to avoid this issue.
I don't remember seeing high memory usage on 2003 Server, so I'm just curious.
Thanks,
John
Let me start by saying that I am not experiencing any serious performance issues with my Progress (10.2A SP1 hot fix 2) database, so this may not be an issue at all.
We recently moved our database from Windows 2003 to 2012. Within a day of going live on the new server, I noticed that the memory utilization (using task manager) stays around 98 to 99% of 32 GB. It stays there until I stop the database and then it drops to around 10 or 15%. After rebooting the server and starting the database it starts out around 18% and then sometime later (usually overnight) after a few users have logged in, it is back up to 99%. Over the weekend, I added another 16 GB of physical memory and by Monday afternoon it was back to 99% with only 3 users logged in (Labor Day).
Like, I said, no performance issues to mention, except after running for about 5 weeks without restarting, we began having slow performance with WebSpeed processes. After restarting the server, the WebSpeed performance was back to normal. I plan to restart the server every couple of weeks to avoid this issue.
I don't remember seeing high memory usage on 2003 Server, so I'm just curious.
Thanks,
John