We are currently running Pervasive SQL on a Netware 3.X machine, single 300mhz processor, and 400 ram. What kind of machine upgrade would we need to be able to run well under NT4?
Recommendations here would be based on application, load, number of users, and other factors you have not included for consideration. Memory and rapid disk access are the two key factors in Pervasive.SQL performance though, so providing that you have proper bandwidth on the network with relatively low utilization (assuming you’re using Ethernet) and a good disk array (duplexed and RAID 0 arrays provide the fastest response with redundancy), I would think that a Pentium III or Xeon 500 or 600Mhz system with 512 MB RAM would be more than sufficient, though your existing system might even work well still. Though NT seems to require 50% to 100% more memory resources than NetWare 4.x, Pervasive.SQL performs about the same on both of them up to 50 or so users and then NetWare seems to have a slight edge because of NetWare’s lower overhead, though field experiences may vary based on many different factors.