Recently, monitoring long running SQL showed that some users are using office to pull data. Because there are no restrictions in the office, every time we capture the data of all operating companies and run very frequently, resulting in a decline in the performance of our ERP system. Find the corresponding developer based on host_name, and they say they are not running at all. This is strange. Where did the host name come from? I checked the office data source and found that it was configured with DSN. There is a parameter"
| Wsid |
Any |
Computer Name |
The name of the Local Computer, sent to server. can be specified only for a DSN-less connection. |
The value of this parameter is the hostname we see, so the problem lies here. Because ODBC-configured data sources are used, users need to reconfigure each time they change their computers or reinstall the system. Therefore, their developers want to save the configuration in this way, you do not need to reconfigure it. So configure the DSN on your computer and send it to the user. In ProgramThe wrong host name is displayed during running. Then I talked to the user about the purpose of using office to pull data. In fact, they just capture the data from the previous day and do not need real-time data. But because they have many people, no one may want to read the data. For this purpose, we recommend that developers set a job to pull a report at night and share it with users. This avoids competition between reports and ERP resources and reduces user waiting time.
