We are experiencing problems with one of our major clients when they run 401 worksheets. They have a server with an HQ database that has 10 stores. Residing on the same server is a substantial Navision database. The HQ server program is running on a separate PC.
When an HQ Client connects and a 401 Data Upload runs, the SQL server program appears to ?lock up? and prevents any access to any of the SQL databases, causing problems with the Navision users.
Our query is should this type of event occur? What is actually happening within the SQL server when a 401 worksheet is being processed? While the HQ Client is processing the data to upload there is little activity within the HQ database server?s CPU and memory. Therefore it is not immediately apparent why the SQL server is unable to process requests within Navision during this period when the 401 worksheet is running.
Is there anyone out there that has similar experiences or installations? Any feedack would be gratefully received.