Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Performance issues with deletion of records in group member table - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Performance issues with deletion of records in group member table
KB0832194

Performance issues with deletion of records in group member table


1286 Views Last updated : Nov 28, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

HI Team, For the business requirement we need to delete some set of record in the(sys_user_grmember). Hence we performed the fix script(delete existing group members for w.area). But we observed after 4 hrs script ran it deleted only 500 record. Could you please help why the deletion is taking too much of time.

Cause

- The deletion is slow as the table is by default subscribed to rollback, which means every record you delete will create a rollback record. This for large   deletions adds up significant time.
- The other thing that happens is the DELETE operation is not properly supported by indexes on table sys_user_has_role.

Resolution

Recommendation to make the delete faster:

1. Disable rollback on table sys_user_has_role (add to the Collection record on Dictionary for table sys_user_has_role the attribute "Exclude from Rollback" (excludeFromRollback) with value true). This will stop rollback recording for any deletions from table sys_user_has_role

2. We need to add an index on table sys_user_has_role on column inh_count.

Once the 2 recommendations above are implemented the deletion should be much faster.

Related Links

If the inh_count column does not exist, follow this kb on how to add it: KB0725210


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.