Beginning with the Istanbul release, the Performance Analytics Scores [pa_scores] table
was split into two tables, Scores Level 1 [pa_scores_l1] and Scores Level 2
This change ensures optimal performance when collecting and analyzing scores, and enables
larger sets of scores. New instances created on the Istanbul release or later use the new scores
tables by default.
For instances created prior to Istanbul, you can migrate your existing data to the new scores
tables. The original Scores [pa_scores] table is truncated 10 days after successful
The scores migration can take several hours to complete, depending on the number
of scores. Schedule the migration in a sub-production instance and then carefully plan the
migration in production.
During migration you cannot collect, modify, or delete scores.
Scheduled data collection jobs will not run during migration. After migration completes, check
any data collection jobs that were scheduled to run during the migration, as these jobs were
After beginning the migration, you can track the migration status by navigating to
If any errors occur during migration, contact ServiceNow Customer Support to resolve the issue.