PDXpert Application Server post-installation checklist

Windows update service for Windows, .NET and SQL Server

In contrast to typical single-user software, multi-user database applications such as PDXpert have demanding communications and infrastructure requirements. As such, they're often more sensitive to unexpected changes in their working environment.

PDXpert software relies upon services provided by Windows and particularly the Microsoft .NET application framework. PDXpert also requires a stable installation of the Microsoft SQL Server database engine.

Windows, .NET and SQL Server updates performed while PDXpert is active can cause unpredictable results.

Always restart the affected computer immediately after any update to Windows, .NET or SQL Server.

  • Close all PDXpert clients before updating the server computer. When the server computer restarts, all active client sessions are automatically closed, and all unsaved work will be lost. Use Windows Server Update Services (WSUS) where appropriate.
  • The PDXpert client can be affected by Microsoft's updates to the server and to the client computer.
    • Ensure all PDXpert clients are closed before restarting the server.
    • Restart the client computer after it has been updated.

Operation and performance considerations

With the PDXpert server console displayed, press the F1 key on your keyboard to open the help topic for configuring the PDXpert Application Server. In the help file Contents, open the How to... section, and review each topic of interest.

For stable operation and good performance:

  • After installation is complete, visit the Microsoft update website to obtain the most recent patches and service packs for SQL Server and the .NET framework.

  • Ensure that you have a frequent and reliable automated backup process. The built-in PDXpert backup facility is a short-term, on-demand solution. Preferred solutions may include one (or a combination) of Windows Backup, third-party utilities that are "SQL aware" and a home-grown scheduled backup.

  • PDXpert Application Server requires exclusive uninterrupted access to the SQL Server database instance called PDXPERT. Avoid stopping, restarting, or otherwise disrupting the SQL Server service or the hosting computer while PDXpert clients are logged into the system.

  • Ensure that the PDXpert server and the clients are whitelisted in your antivirus software. The system and its local client are typically installed into the \Program Files\PDXpert folder; all remote clients are installed into the user profile %LocalAppData%\PDXpert folder.

  • Some antivirus (AV) software can interfere with the PDXpert Application Server, and should be tested for problems while users perform normal database and library file tasks — especially while attaching large or compressed files. If in doubt, exclude the PDXpert server's Data Directory from antivirus scanning. The following image shows the Data Directory location, as displayed on the PDXpert Application Server console's Manage tab.

    Exclude the Data folder from antivirus scan

    On client workstations, aggressive or slow antivirus scanning may interfere with file attachments, particularly large or compressed (e.g., .zip, .rar, .iso) files. If necessary, create a staging directory on the client computer and set the AV software to exclude the folder. Move a file into the excluded folder before attaching it to a record.

  • Do not create new objects within the PDXpertDB database, since unrecognized objects may interfere with proper operation or be deleted without warning.

  • The PDXpert Server requires complete and continuous access to the files it saves in the Data\Library "file attachments" folder. Other applications should not have direct access to these files. Use Windows Volume Shadow Copy Service or similar method to copy library files to an independent location.

  • Use a hard disk (HDD/SDD) with substantial free space. The "file attachments" library usually grows much faster than the rate of database (MDF/LDF) growth. Monitor the disk's free space as needed.

  • If the PDXpert server is installed on a virtual machine, avoid using a dynamically-sized disk. This may cause significant delays when the database or library reaches the disk's limit, and performance degrades because the data is highly fragmented.

  • Do not allow the server computer to go into standby, hibernation or sleep mode. The SQL Server service may take several seconds to wake, and may sometimes require a reboot to begin operation. We do not recommend using the PDXpert Application Server on a laptop or tablet computer.

  • To simplify maintenance and upgrades, we recommend adding to the list of trusted sites the PDXpert *.buyplm.com and (if indexing PDF files) Adobe *.adobe.com websites.

  • The PDXpert Application Server communicates with PDXpert clients using up to four TCP ports beginning at 48084. Ensure that no other services use ports 48084 to 48087.

  • Avoid installing Microsoft Visual Studio on the server, as it may affect system performance.

  • The PDXpert Application Server may automatically purge files or folders within its working directory. Do not add any file to the server's \Data\ folder or its subfolders, since unrecognized files may interfere with proper operation or be deleted.

  • To extend PDXpert server's file indexing capabilities, you can install utilities (called IFilters) that can parse specific file types. For more information, refer to the Fast file content searches using IFilters application note.

  • For best performance within an extremely large library (and provided you have no 16-bit applications installed), disable 8.3 short filenames using the Windows fsutil.exe utility.

  • If you're using SQL Server Express and you have more than 10 users, consider installing a more capable edition.

  • To simplify technical support, download and save the PDXpert TeamViewer for later use.

Use these instructions if you wish to connect SQL Server Management Studio to the the PDXpert system database.

Learn More
Install Guide Contents