Announcement Announcement Module
Collapse
No announcement yet.
JIRA request to add NOLOCK hint in case of SQL Server Instance Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • JIRA request to add NOLOCK hint in case of SQL Server Instance

    Please add "NOLOCK" hint to all SELECTS on Meta Tables in case of Meta Table repository resides on SQL Server instance, to avoind have eclusive table locks during SELECTs.

    For Ex:

    SELECT STEP_EXECUTION_ID, STEP_NAME, START_TIME, END_TIME, STATUS, COMMIT_COUNT, READ_COUNT, FILTER_COUNT, WRITE_COUNT, EXIT_CODE, EXIT_MESSAGE, READ_SKIP_COUNT, WRITE_SKIP_COUNT, PROCESS_SKIP_COUNT, ROLLBACK_COUNT, LAST_UPDATED, VERSION from gssm_etl_batch_STEP_EXECUTION where JOB_EXECUTION_ID = @P0 order by STEP_EXECUTION_ID

    To



    SELECT STEP_EXECUTION_ID, STEP_NAME, START_TIME, END_TIME, STATUS, COMMIT_COUNT, READ_COUNT, FILTER_COUNT, WRITE_COUNT, EXIT_CODE, EXIT_MESSAGE, READ_SKIP_COUNT, WRITE_SKIP_COUNT, PROCESS_SKIP_COUNT, ROLLBACK_COUNT, LAST_UPDATED, VERSION
    from gssm_etl_batch_STEP_EXECUTION (NOLOCK)
    where JOB_EXECUTION_ID = @P0 order by STEP_EXECUTION_ID
Working...
X