How to Use Procdump.exe to Create a Memory Dump for PSQL Engine
If your PSQL server crashes from time to time, then it is necessary to get a memory dump of the PSQL engine processor and send that to Actian tech support for further analysis. The following procedure outlines how to do this.
In order to get a userdump of a process, you will need to get the Microsoft Sysinternals tool called ProcDump. You can download it from here: http://technet.microsoft.com/en-us/sysinternals/dd996900. Unzip it on your server, and we suggest using a directory something like C:\procdump providing that C: has sufficient free space. The size of the dump will be the size of the amount of memory that the process (ntdbsmgr64.exe) is using, which can be many GBs.
Find the Command Prompt on the server, right click and choose to "Run as administrator." See sample screen below:
Navigate to the location where procdump.exe resides. To capture a userdump of a crashing/unloading process, you will need to start ProcDump and let it continue to run until the problem occurs. You can start it with a command line such as:
C:\procdump>procdump -64 -e -ma ntdbsmgr64.exe C:\procdump
C:\procdump is the output location and you can modify that. It will show you something similar to the following:
ProcDump v4.0 - Writes process dump files Copyright (C) 2009-2011 Mark Russinovich Sysinternals - www.sysinternals.com
Process: ntdbsmgr64.exe (1248)
CPU threshold: n/a
Performance counter: n/a
Commit threshold: n/a
Threshold seconds: n/a
Number of dumps: 1
Hung window check: Disabled
Exception monitor: Unhandled
Terminate monitor: Disabled
Dump file: C:\procdump\ntbtrv64_YYMMDD_HHMMSS.dmp
When the exception happens and the file gets written, you can close everything and stop both PSQL relational and transaction engine services, and then restart them to resume.
Zip the dump file (it will compress well) and send it to ftp://ftp.pervasive.com. Contact Actian tech support for FTP upload user id and password. It is likely that you will need to open a support incident to move forward with this incident.
As strange as it may sound, when you have the procdump utility running, then you may never get a crash. We noticed the same behavior happened on both PSQL 11 and 12 engine. We think there is something of the procdump utility that make the PSQL engine more resistant to crash.
EMK
EMK