11 Performance Monitoring
The following performance recommendations are designed to assist administrators in tuning their report job schedules to run optimally based upon the available resources.
Table 11-1 Limits Querying Data (Data Visualizations, Classic Analyses and Dashboards)
| Which compute size do you have? | Limits when querying data for visualizations, analyses, and dashboards |
|---|---|
| Max input rows returned from any data source query | |
|
Small |
2,000,000 |
|
Medium |
2,000,000 |
|
Large |
4,000,000 |
When you query a data source for data visualizations or Classic analyses and dashboards, the compute size determines the maximum number of rows that are returned from the data source.
Table 11-2 Limits Displaying Data (Data Visualization, Classic Analyses and Dashboards)
| Which compute size do you have? | Limits when displaying data in visualizations, analyses, and dashboards |
|---|---|
| Max summarized rows returned from any data source query | |
|
Small |
500,000 |
|
Medium |
500,000 |
|
Large |
1,000,000 |
When you display data in data visualizations or Classic analyses and dashboards, the compute size determines the maximum number of summarized rows returned from the data source that are displayed.
Table 11-3 Limits Exporting Data (Data Visualizations)
| Which compute size do you have? | Limits when exporting data from data visualizations to CSV file |
|---|---|
|
Small |
2,000,000 |
|
Medium |
2,000,000 |
|
Large |
4,000,000 |
When you export data from a data visualization, the compute size determines the maximum number of rows you can export to a CSV file.
Table 11-4 Limits Exporting Data (Classic Analyses and Dashboards)
| Which compute size do you have? | Limits when exporting data from analyses and dashboards | |
|---|---|---|
| Max rows exported to unformatted reports | Max rows exported to formatted reports | |
|
Small |
2,000,000 |
200,000 |
|
Medium |
2,000,000 |
200,000 |
|
Large |
4,000,000 |
400,000 |
When you export data from analyses and dashboards, the compute size determines the maximum number of rows you can export. There are different limits for formatted data and unformatted data.
-
Unformatted data limits: formats such as CSV, Excel, XML, and Tab Delimited.
-
Formatted data limits: formats such as PDF, Excel, Powerpoint, and Web Archive/HTML.
Note: When two pivot views are laid out side by side in a union the formatted export limit will be 20,000 rows.
Table 11-5 Limits Delivering by Email (Classic Analyses and Dashboards)
| Which compute size do you have? | Limits when delivering analyses and dashboards by email | |
|---|---|---|
| Max rows in unformatted reports delivered by email | Max rows in formatted reports delivered by email | |
|
Small |
200,000 |
50,000 |
|
Medium |
200,000 |
50,000 |
|
Large |
300,000 |
100,000 |
If you plan to send analyses and dashboards by email, the compute size determines the maximum number of rows you can deliver in a single email. There are different limits for delivering formatted data and unformatted data.
-
Unformatted data limits: formats such as CSV, Excel, XML, and Tab Delimited.
-
Formatted data limits: formats such as PDF, Excel, Powerpoint, and Web Archive/HTML.
Table 11-6 Data Size Limits (Classic Pixel-perfect Reports)
| Which compute size do you have? | Report data size limits when generating pixel-perfect reports | |||
|---|---|---|---|---|
| Max data size for online reports | Max data size for offline (scheduled) reports | Max data size for bursting reports | Max data size for data generation | |
|
Small |
500MB |
2GB |
4GB |
2GB |
|
Medium |
500MB |
2GB |
4GB |
2GB |
|
Large |
500MB |
4GB |
8GB |
4GB |
If you plan to generate pixel-perfect reports, the compute size determines several limits associated with report generation.
Table 11-7 Processing Limits (Classic Pixel-perfect Reports)
| Which compute size do you have? | Data model and report processing limits when generating pixel-perfect reports | ||||
|---|---|---|---|---|---|
| SQL Query timeout for scheduled reports (seconds) | Max rows for CSV output | Max number of in-memory rows in XPT layout | Max number of concurrent scheduled jobs | Max number of concurrent online reports | |
|
Small |
1,800 |
4,000,000 |
200,000 |
4 |
46 |
|
Medium |
1,800 |
4,000,000 |
200,000 |
4 |
96 |
|
Large |
3,600 |
6,000,000 |
300,000 |
10 |
480 |
If you plan to generate pixel-perfect reports, the compute size determines several limits associated with report processing.