We are currently running MS SQL 2000 on a IBM server and need to add a new application that needs Pervasive SQL v8. I would like to run both on the same server if possible. Has anyone done this successfully or do I need to get another server?
do NOT set pervasive to 'minimial state if inactive'. That will crippe your pervasive app, and cause other issues.
If you server has a 1G of RAM, allocate 350M to SQL server and 350M to Pervasive and leave them. Adjust the ratio to suit, ie 600, 100 if sql is heavily used and pervasive isn't. Just make sure you don't over commit, particularly sql server which by defaults will use all the RAM on the machine.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.