Subarea:
N/A
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.
SELECT
[ReadLatency]
=
CASE
WHEN
[num_of_reads]
0
THEN
ELSE
(
[io_stall_read_ms]
/
)
END
,
[WriteLatency]
[num_of_writes]
[io_stall_write_ms]
[Latency]
AND
[io_stall]
+
[AvgBPerRead]
[num_of_bytes_read]
[AvgBPerWrite]
[num_of_bytes_written]
[AvgBPerTransfer]
LEFT
[mf]
.
[physical_name]
2
AS
[Drive]
DB_NAME
[vfs]
[database_id]
[DB]
FROM
sys.dm_io_virtual_file_stats
NULL
JOIN
sys.master_files
ON
[file_id]
-- WHERE [vfs].[file_id] = 2 -- log files
-- ORDER BY [Latency] DESC
-- ORDER BY [ReadLatency] DESC
ORDER
BY
DESC
;
GO
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.