Troubleshooting DVMAX Server Performance

Owned by John Bellos (Unlicensed)
Last updated: Mar 01, 2018 by Amy Blanchard
3 min read

Several factors can affect the performance of DVMAX - some controlled by DVMAX, while many other variables exist that extend beyond that. The purpose of this document is to have all of the commonly requested information required to troubleshoot any complex performance-related case with DVMAX.

Explanation of Performance Problems

Please include a detailed summary of the problem you're experiencing. Information such as specific actions you took, how long it took to execute, and the _full_ errors received if any are very helpful. Comments such as 'it's slow' or 'freezes' or 'crashes' with no additional information is not enough to assist in diagnosing the issue. Pictures or Screenshots are also welcomed and encouraged.


Hardware


Server

Is this a Virtual Server?
If so, is the host serving any other virtual servers?           If so, what are the other server's tasks or applications that run there?

Operating System & Version (ie. Mac 10.9.3 or Windows 8.1):
Processor Type and Speed (# of cores if possible):
RAM:

Hard Drive subsystem

Controller:
RAID Type:
# of Disk Drives:
Model of Disk Drives:

Active network type and model (Wired/Wireless and Model):

Workstations


For the information below, please answer the questions based on all the computer types that have been affected by the problem you're reporting.

# of possible concurrent workstation connections (licensed for):
Operating Systems and Versions:

Processor Type and Speed:
RAM:
Video Card/Driver:
Active network type and model (Wired/Wireless and Model):



Software

On the DVMAX Server are there any other applications that run other than DVMAX?
Backup Type & Version (BackupExec, MozyPro, TimeMachine, etc):
Antivirus Type & Version on Server (Symantec, Trend, etc.):
Antivirus Type & Version on Workstations (Symantec, Trend, etc.):

What is the Max Cache value set to for DVMAX?
What time does the DVMAX Backup run?

Scheduled Tasks (please list all tasks and what time they run):

Are there any applications that extract Data from DVMAX?
If so, list their names, and any times you know of that they run:

DVMAX Modules Used

Please answer Yes/No/Don't know to the following points.

If you are using DVMAX Practice..

Sync/Remote Processing:
Credit Card Processing:
MPA/Replication:
VetStreet:
Boarding:
Appt Scheduler:
Treatment Plans:

If you are using DVMAX Research...

Are you using the AFMS/ Record Import feature?
If so, what is the schedule/frequency/quantity of records being added to DVMAX?



Record Counts & Logs

Please include a record count of all tables in your database. To do this:
Log into DVMAX Client as Administrator.
Go to Section -> General Management.
Click on the Utilities tab.
Choose Record Count Report.
Choose Export when prompted.
Save the file as RecordCounts.txt and include it with this submission.

Submit a day's worth of logging that covers a period time that you experienced performance issues.

Logs

- Web Log

Macintosh:

On the Server go to File -> Database Settings -> Web -> Log (Type) -> Select CLF (Common Log Format) from the Log Format drop down -> OK
Note: You must restart DVMAX for this to take effect.

Windows:

On the Server go to Edit -> Database Settings -> Web -> Log (Type) -> Select CLF (Common Log Format) from the Log Format drop down -> OK
Note: You must restart DVMAX for this to take effect.

Information Component

The following article explains how to enable and start the information component logging:
Monitoring 4D Server / Information Recorder
Note: This logging is only good for the duration of DVMAX Server's uptime. If you quit/relaunch DVMAX, this logging will stop.

Data size

On the DVMAX Server, navigate to your Data folder. Typical locations are:

Windows: C:\DVMAXDatabaseFiles/DVMaxDataFolder\
Macintosh: Documents::DVMAXDatabaseFiles::DVMaxDataFolder

Note the size of your .4DD file and record it here: 



Network


Please list all hops; Routers/Switches that  are passed between a Client / Server connection. For example:

                                                                           Cable Modem & Firewall Model XXXX
                                                                                          |
Client computer -> Linksys 4 port Switch Model XXX -> Linksys 20 port switch Model XXXX -> DVMAX Server