Microsoft Windows 10, Windows 8, or Windows 7 using Internet Explorer 11, Firefox, or Chrome. Goldstar Software Inc.MacOS v10.12 or later using Safari 10 or later, Firefox, or Chrome. (Updated June 2018) Ĭopyright © 1997-2023, Goldstar Software Inc., All rights reserved. Check out this paper to see if you are being impacted by this issue. Microsoft broke quite a few things in their Windows 10 Release 1803 patch. ![]() Problems Caused by Windows 10 Release 1803 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)Ĭapturing Virtual Bytes to a Log File (And Graphing it in Excel) 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. This infomration is critical knowledge to have before reading the next paper. ![]() This paper discusses the various server memory counters available in Windows, and how to find them out for your environment. This paper details how to activate client-side Tracing within Actian Zen v15.10 and above (which differs from v15.00 and earlier). Using the Trace Requesters in Zen v15.10 and Above This paper details how to activate the Debug Requesters (also known as the Trace Requesters), used to analyze client-side issues. This paper discusses how to use Performance Monitor (PerfMon) to capture performance metrics and counters within your server (or workstation) to understand what is occurring inside, and to hopefully identify the most obvious bottleneck in the environment. This paper discusses how to use Process Monitor (ProcMon) to get a trace of your environment's registry and disk accesses, which can help assess issues with both functionality and performance. Having such a trace can lead to quicker resolution of problems you may encounter. This paper discusses how to use Wireshark to get a network trace of your failing environment. Having a valid trace leads to quicker resolution of problems you may encounter. This paper discusses how to get a Microkernel Database Engine trace to show the exact point at which an application fails. Obtaining an MKDE Trace to Troubleshoot a Failing Application ![]() This paper discusses how to get a memory dump of the Pervasive database process on Windows Servers using the older UserDump tool. Grabbing a Windows Memory Dump with UserDump (Old) This paper discusses how to get a memory dump of the database engine process on Windows Servers. Grabbing a Windows Memory Dump with ProcDump (New) This article explains what the startup process should look like on a client/server system connecting to a remote server for the first time. Here's how to use this new tool! (Released December 2015) In addition to rebuilding, PSQL v12 offers the Online Database Defragmenter (ODD) to reclaim unused space while your system is life. Note: If you have corrupted files in need of recovery, please see the paper above on Data File Maintenance. Here's how to do it! (Updated November 2018) Rebuilding files to the latest file format can often provide substantial performance and stability gains. Note: If you have valid files and you just want to rebuild them to reclaim deleted space, please see the paper below. What does it take to recover corrupted Btrieve data files? This excerpt from our first Service & SupportĬlass covers most of the basics for you! (Updated April 2010) These documents are in Adobe Acrobat PDF format. which cover issues related to maintaining and troubleshooting the Pervasive database. ![]() This page contains white papers created by Goldstar Software Inc. White Papers: PSQL/Zen Maintenance and Troubleshooting NOTE: Order processing and tech support will be slower than normal from March 20-24 due to vacations.
0 Comments
Leave a Reply. |