Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenPlant | AutoPLANT
  • Product Communities
  • More
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki SQL Server IO Latency - BRCM
    • Sign in
    • -OpenPlant | AutoPLANT Wiki
      • +OpenPlant
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • -Bentley Raceway and Cable Management
        • How to Download Bentley Raceway and Cable Management
        • Bentley Raceway and Cable Management Product Compatibility
        • -CONNECT Edition - Bentley Raceway and Cable Management
          • +Resolved issues in Bentley Raceway and Cable Management Releases
          • +What's New in Bentley Raceway and Cable Management Releases
          • +Manufacturer Based Raceway Content in Bentley Raceway and Cable Management
          • +AutoPlace Conduit tool - BRCM CONNECT Edition
          • +Cable Reports- Cable Pull Cards and Cable Drums-Bentley Raceway and Cable Management CONNECT Edition
          • +Cable Routing-Bentley Raceway and Cable Management CONNECT Edition.
          • +Drawing generation - Bentley Raceway and Cable Management CONNECT Edition
          • +i-Model - Bentley Raceway and Cable Management CONNECT Edition
          • -Installation_Configuration - BRCM CONNECT
            • Configuration Files - BRCM
            • Configuration Variables - BRCM
            • Database Replication for Bentley Raceway & Cable Management
            • How to configure Bentley Raceway and Cable Management CONNECT Edition with SQL database using Windows Authentication.
            • How to configure BRCM database connection string without the requirement of ODBC DSN.
            • How To create Deployment Image for BRCM CONNECT
            • How to Deploy a Shared WorkSpace in BRCM CONNECT Edition
            • How to do Silent installation of Bentley Raceway and Cable Management CONNECT Edition
            • How to install BRCM CONNECT Edition
            • How to Install BRCM CONNECT in a custom location
            • SQL Server IO Latency - BRCM
            • To assign Minimum SQL User Permissions for Bentley Raceway and Cable Management.
          • +Power Platform Support - BRCM CONNECT Edition
          • +Project Setup- Bentley Raceway and Cable Management
          • +ProjectWise Integration - Bentley Raceway and Cable Management CONNECT
          • +Raceway Design Tools - Bentley Raceway & Cable Management
          • +Raceway IDs - Bentley Raceway and Cable Management CONNECT
          • +Reports - Output Manager - BRCM CONNECT Edition
          • +Underground System - Bentley Raceway and Cable Management CONNECT Edition
          • +User Defined Attributes (UDA) Settings - Bentley Raceway and Cable Management CONNECT Edition
          • +Components Center - Bentley Raceway and Cable Management CONNECT Edition
          • +i-Twin Services-Bentley Raceway and Cable Management CONNECT Edition.
          • +Equipment & Cable List Import-Bentley Raceway and Cable Management CONNECT.
          • +Interoperability
        • +V8i - Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

     
     Questions about this article, topic, or product? Click here. 

    SQL Server IO Latency - BRCM

    Product(s): Bentley Raceway and Cable Management CONNECT Edition
    Version(s): 10
    Environment: N/A
    Area: Installation_Configuration

    Subarea:

    N/A

    Background

    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.

    Steps

    1. First, you must install Microsoft SQL Server Management Studio on the client machine if you don't already have it. You can download it from Microsoft.
    2. Launch Microsoft SQL Server Management Studio and connect to the BRCM SQL Server database.
    3. Select the New Query button to open a new query window and paste the following query in it:
    SELECT
        [ReadLatency] =
            CASE WHEN [num_of_reads] = 0
                THEN 0 ELSE ([io_stall_read_ms] / [num_of_reads]) END,
        [WriteLatency] =
            CASE WHEN [num_of_writes] = 0
                THEN 0 ELSE ([io_stall_write_ms] / [num_of_writes]) END,
        [Latency] =
            CASE WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0)
                THEN 0 ELSE ([io_stall] / ([num_of_reads] + [num_of_writes])) END,
        [AvgBPerRead] =
            CASE WHEN [num_of_reads] = 0
                THEN 0 ELSE ([num_of_bytes_read] / [num_of_reads]) END,
        [AvgBPerWrite] =
            CASE WHEN [num_of_writes] = 0
                THEN 0 ELSE ([num_of_bytes_written] / [num_of_writes]) END,
        [AvgBPerTransfer] =
            CASE WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0)
                THEN 0 ELSE
                    (([num_of_bytes_read] + [num_of_bytes_written]) /
                    ([num_of_reads] + [num_of_writes])) END,
        LEFT ([mf].[physical_name], 2) AS [Drive],
        DB_NAME ([vfs].[database_id]) AS [DB],
        [mf].[physical_name]
    FROM
        sys.dm_io_virtual_file_stats (NULL,NULL) AS [vfs]
    JOIN sys.master_files AS [mf]
        ON [vfs].[database_id] = [mf].[database_id]
        AND [vfs].[file_id] = [mf].[file_id]
    -- WHERE [vfs].[file_id] = 2 -- log files
    -- ORDER BY [Latency] DESC
    -- ORDER BY [ReadLatency] DESC
    ORDER BY [WriteLatency] DESC;
    GO
    4. Select the Execute button to run the query which should produce a table like the one shown below:

    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:

    Performance Latency Range
    Excellent < 1ms
    Very good < 5ms
    Good 5-10ms
    Poor 10-20ms
    Bad 20-100ms
    Very Bad 100-500ms
    Extremely Bad > 500ms

    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.

    • CONNECT Edition
    • Administration
    • en
    • bentley raceway and cable management
    • Installation_Configuration
    • Share
    • History
    • More
    • Cancel
    • Scott Walker Created by Bentley Colleague Scott Walker
    • When: Thu, Dec 5 2019 2:04 PM
    • Scott Walker Last revision by Bentley Colleague Scott Walker
    • When: Thu, Dec 5 2019 2:12 PM
    • Revisions: 6
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies