Goldstar Logo
Your Source for PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
+ Actian Zen v13
+ Actian PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve v12
+ Btrieve 6.15

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users: Click Me Fix My PSQL License Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

White Papers About Pervasive PSQL Maintenance and Troubleshooting

By: Bill Bach

This page contains white papers created by Goldstar Software Inc. which cover issues related to maintaining and troubleshooting the Pervasive database.

Click on the PDF icon to download the complete document in Acrobat format. Can't open the PDF files? Please visit www.adobe.com for a free download of Adobe Acrobat Reader.

PDFUsing Continuous Operations For Proper Backup
This paper is provided to explain to you the benefits and inner workings of Continuous Operations Mode, a database feature that allows you to take snapshot backups of your data at any time. (Updated March 2010)

PDFMonitoring Your Database With Continuous Operations
This Pervasive Tech Tip (written by Goldstar Software) provides helpful information for monitoring your database backups with Continuous Operations Mode to ensure that nothing goes wrong, or that you are at least informed when the process does experience a problem. (Updated April 2010)

PDFBtrieve Data File Maintenance
What does it take to recover corrupted Btrieve data files? This excerpt from our first Service & Support class covers most of the basics for you! (Updated April 2010)
Note: If you have valid files and you just want to rebuild them to reclaim deleted space, please see the paper below.

PDFRebuilding Database Files to the Newest File Format
Rebuilding files to the latest Pervasive file format can often provide substantial performance gains. Here's how to do it! (Updated March 2010)
Note: If you have corrupted files in need of recovery, please see the paper above on Data File Maintenance.

PDFUsing the Online Database Defragmenter
In addition to rebuilding, PSQL v12 offers the Online Database Defragmenter (ODD) to reclaim unused space while your system is life. Here's how to use this new tool! (Released December 2015)

PDFChecking Your Pervasive Server CPU Performance
This paper details one process for confirming the performance of your core CPU on the Pervasive database server environment. (Updated November 2010)

PDFTesting your Network with the Pervasive System Analyzer
This article explains how to test your network's communications speed and reliability with the Pervasive System Analyzer, or via SmartScout for old environments. (Updated March 2010)

PDFPervasive PSQL Startup Process
This article explains what the startup process should look like on a client/server system connecting to a remote server for the first time. (Updated September 2011)

PDF Grabbing a Windows Memory Dump with UserDump
This paper discusses how to get a memory dump of the Pervasive database process on Windows Servers. (Updated December 2006)

PDF Grabbing a Windows Memory Dump with ProcDump (New)
This paper discusses how to get a memory dump of the Pervasive database process on Windows Servers. (Updated August 2016)

PDFObtaining an MKDE Trace to Troubleshoot a Failing Application
This paper discusses how to get a Microkernel Database Engine trace to show the exact point at which an application fails. Having a valid trace leads to quicker resolution of problems you may encounter. (Updated March 2010)

PDFCapturing Network Traffic With Wireshark v1.x
This paper discusses how to use Wireshark to get a network trace of your failing environment. Having such a trace can lead to quicker resolution of problems you may encounter. (Updated February 2014)

PDFCapturing Network Traffic With Wireshark 2
This paper discusses how to use Wireshark v2.0 to get a network trace of your failing environment. Having such a trace can lead to quicker resolution of problems you may encounter. (Updated December 2015)

PDFUsing the PSQL Debug Requesters
This paper details how to activate the Debug Requesters (also known as the Trace Requesters), used to analyze client-side issues. (Updated September 2017)

PDFUnderstanding Server Memory Counters
This paper discusses the various server memory counters available in Windows, and how to find them out for your environment. This infomration is critical knowledge to have before reading the next paper. (Updated September 2010)

PDFInterpreting Server Memory Counters
This paper expands on the above by showing you how to interpret the various server memory counters which can impact the performance and stability of your database engine. (Updated September 2010)

PDFCapturing Virtual Bytes to a Log File (And Graphing it in Excel)
This paper details the process for collecting a single Performance Monitor counter (such as Virtual Bytes) from an active server, and then details a process to quickly graph the results to help analyze the resulting data. (Updated September 2010)

For more papers, see the Google+ link.

  Copyright © 1997-2017, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 3007 Carmel Dr | Flossmoor IL 60422 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us