Database rotation
The longer an instance runs and usage increases, the amount of data stored in tables increases over a period of time. More and more system logs and tasks are created each day causing the datasets to increase in size and negatively impact the database performance. Systems tasks, such as indexing can further impact the performance when the dataset in question is huge.
The database rotation feature available in the ServiceNow platform can be used to improve the database performance and avert any unknown risks associated with large datasets. The database rotation can be used to separate a large dataset into smaller ones thus improving the system performance.
The database rotation feature offers two possible techniques to administrator and to improve the performance by reducing the amount of data in a table:
- Table rotation: A table rotation works by creating a subset of data at a regular specified interval and maintains the records in subset tables till the number of rotations...
