SN System Properties Reference
Property reference

com.snc.pa.dc.hsql.max_row_count_indicator_source

The property sets the maximum number of rows that can be fetched from an Indicator Source during optimized data collection. Admins should review this setting to ensure performance is balanced with data retrieval needs, especially in large datasets.

Default: 1000000 Type: integer Application: Global

Key questions about this property

The answers below summarize the purpose, scope, default effect, and review scenarios for this property.

What does it do? It limits the number of rows retrieved from an Indicator Source to enhance performance during data collection processes.
What area does it affect? Data Collection Optimization
What does the default mean? The default value is "1000000", which sets the baseline numeric behavior for this property.
When should you review it? Review this property when adjusting data collection strategies or when performance issues arise.

Out of the box property record

Raw metadata from the property record.

Property name com.snc.pa.dc.hsql.max_row_count_indicator_source
Sys ID 642559d9c3d01110af6771b1d840dd60
Type integer
Application Global
Default value 1000000
Description Maximum number of rows that are allowed to be fetched from an Indicator Source in optimized data collection
Updated 2024-05-25 04:34:26

Sources

Official references and nearby text excerpts where this property appears.

Documentation excerpt View supporting context
Context preview Snippet 1
... for Count Distinct aggregation. Note: The default maximum number of records allowed per indicator source for data collection has been increased for optimized data collection. For more information, see the com.snc.pa.dc.hsql.max_row_count_indicator_source property in Performance Analytics properties. The optimizations stem from the use of an embedded database. A standard data collection job stores all scores in the node memory during the job. ...
Documentation excerpt View supporting context
Context preview Snippet 2
... an indicator source. This property only applies to jobs that do not use Optimized data collection . • Type: integer • Default value: 50000 • Location: System Property [sys_properties] table com.snc.pa.dc.hsql.max_row_count_indicator_source Maximum number of rows that are allowed to be fetched from an Indicator Source. This property only applies to jobs that use Optimized data collection . • Type: integer • ...
Documentation excerpt View supporting context
Context preview Snippet 3
... in step five. 12. Add a breakdown mapping on the test_incident and ref_breakdown field. 13. Navigate back to the indicator. 14. Add the breakdown. 15. Change the system properties: a. com.snc.pa.dc.hsql.max_row_count_indicator_source => 10000000. b. com.snc.pa.dc.max_breakdown_elements_limit => 10000000. 16. Collect 1-day score for the indicator. 17. Create a new dashboard. 18. Add a visualization: © 2026 ServiceNow, Inc. All rights reserved. ServiceNow, ...
Additional source link Another external reference for this property
Open reference