Statistics
The Highest Post







Statistics
Count 94
Avg 21.00
Min 21
Max 21
Angualr Top questions

Details



Monitor your table growth rates When you check your table growth, you’ll look for two things: • Dramatic changes in size from month to month • The total number of records in your tables Follow these steps: 1. Navigate to System Definition. 2. Select Tables. 3. Your list of tables appears on the screen 4. Filter the table information by typing u_ in the box. This will show you all of the user-created tables. 5. Continue filtering the table by typing =NULL under Column name. This shows you all your customized tables (those that aren’t out of the box)—the tables you need to check for growth. 6. To see the total number of records in a table, type name of table.list in the navigation field at the top left of the screen 7. Look for a dramatic change between the previous month and this month. If you see this, you may need to investigate why the spike occurred. 8. Check the total records. If the total number of records in your tables is over 50K, you may need to complete one of these tasks or a combination of them: • Index the fields used in filters or other queries – To determine if you need to index fields, review the Slow Queries log. If you discover that you need to index, contact ServiceNow for support. • Request a table rotation from ServiceNow technical support – For more information, read the next section and our product page on table rotation. • Extend your tables – For more information, read our product page explaining the table extension. • Clean them by purging rows – See the next section
Related Topics