In order for database updates to perform well, you must ensure that your IO latency from the Bentley Raceway and Cable Management client machine and your SQL Server is good. This article will explain how to measure your current latency and judge whether it is performing well or not.
-- WHERE [vfs].[file_id] = 2 -- log files
-- ORDER BY [Latency] DESC
-- ORDER BY [ReadLatency] DESC
5. Locate the entry for the BRCM database and read the latency value from the "Latency" field and compare your value with the following chart to determine if your latency is within an acceptable range:
If your performance is in the poor or worse ranges you will likely experience performance problems when executing the Update Database feature. In such circumstances, you should consult with your IT department to troubleshoot the concern and remedy the situation.