Performance issues..please help
Performance issues..please help
(OP)
hi..
psql 9.5 with sp2.
struggling bad with performance..
i check the performance monitor often to see that the:
pages per sec averages at around 300
average disk queue averages from 3 - 6
i asked the application guys and they had me change a few settings in the pervasive control center...but that didn't do much at all..
all of the users are going crazy..
dual xeon 3.0Ghz with 2GB of RAM..the CPU and RAM are fine performance wise (seems to be so anyway).
any suggestions would be greatly appreciated. thanks
Edit/Delete Message
psql 9.5 with sp2.
struggling bad with performance..
i check the performance monitor often to see that the:
pages per sec averages at around 300
average disk queue averages from 3 - 6
i asked the application guys and they had me change a few settings in the pervasive control center...but that didn't do much at all..
all of the users are going crazy..
dual xeon 3.0Ghz with 2GB of RAM..the CPU and RAM are fine performance wise (seems to be so anyway).
any suggestions would be greatly appreciated. thanks
Edit/Delete Message
RE: Performance issues..please help
Specifically, you need to tell us what the application is actually doing.
From one of my posts on the other site:
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Performance issues..please help
i'm also curious about the server.. but i'm still sceptical that an upgrade to an e.g 2 x dual core server might not even make it much better..
what are your thoughts? thanks
RE: Performance issues..please help
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com