SQL Server Performance Forum – Threads Archive

PervasiveSQL performance increasing

Hi Folks, I am new to www.sql-server-performance.com . We have a 2Gig PervasiveSQL Database on our server that really is starting to choke. I was wondering if there is anyone here who is expereinced in PervasiveSQL and tweeking its performance. Currently our server is stuck at 2gig so upgrading ram is not really an option. I might change the entire server to install more ram … but I want to exhaust my options before I drop 15K on a new database server. Ideas:
Install new Raid5 array,
Data on Raid5 (four drives)
Windows OS on Raid 1
PervasvieSQL temp files onto a separate single drive Anyone have any input. Has anyone else had to build a high performance DB server using PervasiveSQL ? Any input would be greatly appreciated. Les Elton
Network Admin.
ABC Recycling Ltd

As this here is SQL Server country, you might have more luck asking your question to a community dedicated to your RDBMS. You can find one here:<a target="_blank" href=http://www.dbforums.com/>http://www.dbforums.com/</a> Good luck! [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstÃ¯Â¿Â½tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

Thanks Frank, that puts me in the right direction

]]>