Using Windows Process Explorer to Obtain Thread Call Stacks
Process Explorer is a Microsoft tool useful in viewing the internal properties of a Windows executable process. It can be a very valuable tool in observing FairCom DB behavior when things are not functioning as expected. Follow these steps to use this tool in viewing FairCom DB threads in process:
Download Process Explorer and install it.
Run Process Explorer and select the ctsrvr.exe or ctreesql.exe process. Right-click and select Properties.
Select the Threads tab. Select the thread that is showing the most CPU use and click the Stack button.
Click copy to copy the stack and send the resulting file to FairCom for analysis if requested.
Here's a screen snapshot showing a typical FairCom DB thread call stack: