Pervasive PSQL v11
Posted on 2014-04-01
I have upgraded everything (I do mean everything), desktops, servers, cabling, switches, you get the point. I have also upgraded Timberline to (new name) Sage 300 construction with comes with Pervasive PSQL v11. Since the upgrade the software runs terrible. Freezes throughout the day, long delays processing data (read or write) and lots of complaints. I have been working with Sage tech support and they have made it better (made some adjustments to the server and memory allocation) however we are at a standstill for improving the performance. Everything else on the server runs great, just not Sage construction. Anyone have any ideas what could be happening and how it could be corrected? Here are the details:
Lenovo RD630 with dual Xeon CPU's
1.8tb of storage in a RAID 1+0
3 network cards gigabit - 1 for the users and 2 for the VM environment
3 virtual servers (low usage servers)
Windows server 2012 standard
160gb hard drive
windows 7 64-bit
Sage 300 construction (timberline) runs great from the server. I have tested with limited users which works OK. Its better with less users than our normal 9. However I have not performed good testing with limited users to make an accurate comparison.
Watching the servers performance tells me there is nothing wrong with the server. Working with file transfers yields the highest network throughput possible. Working with the MSQL databases are fine. Basically I am at the WTF point with this software system. Any help would be great.