Delphix Products

 View Only
  • 1.  DBCC CHECKTABLE PHYSICAL_ONLY Frequency change

    Posted 07-20-2022 12:27:00 PM
    Are there any options to modify the frequency at which Delphix performs DBCC CHECKTABLE PHYSICAL_ONLY on a MSSQL VDB?

    Though its known that PHYSICAL_ONLY option is very low on CPU/Memory intensity, however some of the database developers find it a little concerning.

    ------------------------------
    Mahesh Chandran
    Delphix Community Members
    ------------------------------


  • 2.  RE: DBCC CHECKTABLE PHYSICAL_ONLY Frequency change

    Posted 07-20-2022 05:51:00 PM
    Hello Mahesh-

    Somtiemes these intervals are 'hard-coded', but we could speak to this in more detail through a Support engagement. In some instances, these intervals can be controlled by a tunable parameter, though there's no customer-accessible interface for this. 

    However, these checks are frequently tied to interval values related to Environment and object monitoring, so the trade-off to any adjustment is potentially a larger amount of time between any dataset or Environment issue occurring, and it's detection by Delphix.

    The change to DBCC CHECKTABLE as you mention is a recent enhancement (6.0.15.0, referenced in release notes under DLPX-81100) intended to be a more lightweight method of determining the Dataset health, and as you mention, is less costly, so it would be ideal to work with your team to understand the reasons for this monitoring and to adjust expectations, so we may alert as promptly as possible to any access issues, etc.

    If this doesn't resolve your query, please let us know through a Support case and we can discuss in greater detail.

    ------------------------------
    Sean Nothdurft
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------