Route SQL API calls to Read Replica

  • Release version: Australia
  • Updated March 15, 2026
  • 1 minute to read

    • You can route SQL API calls to Read Replica to optimize the performance of your ServiceNow instance.

    Before you begin

    You must have a secondary database configured for your ServiceNow instance.

    Role required: admin

    About this task

    Query routing takes the load off the primary database for SELECT queries that take numerous DB CPU cycles on the primary DB. For more information, see Introduction to ServiceNow Read Replica Databases.

    Procedure

    1. Navigate to All > Secondary Database > Secondary Database Category.
    2. Select New to create secondary database category for ODBC/JDBC.
    3. In the Name field, enter odbc or jdbc.
      Don't change any other field on this page. If you must change the default values, first refer to this KB: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0824441 UI screen example for creating secondary database category.
    4. Select Map All Pools to map the database pools to this category.
    5. Select the database pools to be added.
      The selected pools appear under the Member Secondary Database Pools.
    6. Select Save.