...
| Indicator | Description |
|---|---|
| Largest response time | The largest response time in milliseconds for all page requests across the entire web site. To view the response time for individual pages, see Page Response Time. |
| Largest query execution time | The largest query execution time is the execution time of the longest of all SQL queries performed on all databases. To view the query execution time for individual queries, see the Queries tab. |
| Largest response time Page Generator | The largest response time in milliseconds the Page Generator took to fulfill a request. To view the Page Generator response time for individual pages, see the Page response time tabResponse Time. |
| Average response time Page Generator | The average response time in milliseconds that the Page Generator took to fulfill requests. To view the Page Generator response time for individual pages, see the Page response time tabResponse Time. |
| Average response time | The average response time in milliseconds for all page requests.To view the response time for individual pages, see the Page response time tabResponse Time. |
| Average query execution time | The average query response time is the average for all SQL queries performed on all databases. To view the query execution time for individual queries, see the Queries tab. |
Settings
The settings tab shows the status of XperienCentral settings that can affect performance. In the "Status" column, you can click the orange and red indicators for more information on the meaning of the indicator itself and what you can do in order to improve the performance for the related item.
...
The pages listed in the "Slowest Pages from the Page Generator" list are pages requested from the website that were generated by the Page Generator and not taken from the cache. The pages in this list are a subset of the pages in the "Slowest pages" list and will always appear in the "Slowest Pages" list as well. See the section Lowering Page Response Times for troubleshooting information.
...
The pages listed in the "Slowest Pages" list are the pages requested from the website that took the longest time to load from the cache and/or be generated by the Page Generator. The pages that took the longest time to be generated by the Page Generator are also listed separately in the "Slowest Pages Page Generator" list. See the section Lowering Page Response Times for troubleshooting information.
...
| Note |
|---|
Not all pages in the list are viewable due to context-related factors. If the page cannot be displayed, a JavaScript error will be returned. |
To refresh the list, click [Refresh this page]. To clear the list, click [Clear list]. For information about steps you can take to improve the performance of slow pages,
...
See Lowering Page Response Times.
...
Page Cache Ratio Indicators
...
To refresh the list, click [Refresh this page]. To clear the list, click [Clear list]. For information on improving cache ratio, see the section Lowering the cache ratio.
...
| Anchor | ||||
|---|---|---|---|---|
|
Use the Queries tab to monitor and examine the queries that have taken the most time (the slowest). To enable query monitoring, select "Monitoring enabled":
...
After query monitoring is enabled, the speed of all queries performed by XperienCentral will be monitored. In the 'Slowest Queries' list, the slowest query monitored appears at the top of the list. The queries that appear in the list are those that have run since monitoring was enabled or since the last time that the list was cleared using the [Clear list] button.
To see the full query, click it in the list. In the 'Details' box the full query appears. From here you can also copy the query and paste it in another application:
To refresh the list to see the latest queries, click [Refresh this page]. To clear the list, click [Clear list].
...
If caching is enabled in XperienCentral, a green indicator is shown and if it is disabled, a red indicator is shown. Caching allows XperienCentral to handle the load created by many page requests by using an intelligent mechanism that returns pages without having to regenerate them completely every time they are requested. In all cases, caching improves website performance and it is highly recommended that you enable it for your website.
To enable/disable caching, run the Setup Tool. On the [General configuration] tab, navigate to the "Frontend_System_Settings" section and select "allow_cache":
For more information on caching in XperienCentral, see the Caching.
...
The caching module of XperienCentral stores a timestamp in the timestamp database for each cached web page. This timestamp is needed in order to determine whether the web page needs to be regenerated or whether it can be retrieved from the cache. For high volume websites, the number of web page requests per second can be so high that even the relatively simple task of performing one SQL query to retrieve this timestamp from the database can cause a bottleneck. If this exceeds 500 milliseconds, it may indicate a performance issue.
To prevent timestamp retrieval from becoming a bottleneck, timestamps can be cached in memory for <n> milliseconds. Note that this also causes a delay of <n> milliseconds; during the <n> milliseconds, modified web pages will not be regenerated. It is recommended that you set timestamp caching to at least 5000 milliseconds (5 seconds). If you set timestamp caching to fewer than 5000 milliseconds, this can cause database bottlenecks especially for websites that experience a large number of page requests.
Timestamp caching is configured in the XperienCentral Setup Tool. Navigate to the "Frontend System Settings" section of the [General configuration] tab:
| Anchor | ||||
|---|---|---|---|---|
|
Page response time performance for pages returned from the cache as well as pages generated by the Page Generator is measured in the following way:
...
A large average response time can also be caused by XperienCentral caching settings. If caching is disabled, every time a page is requested it must be generated. This can lead to large page response times, especially if your website has many visitors simultaneously requesting pages. See the section on XperienCentral caching Caching for more information.
Lowering Query Execution Times
...
The level at which you log messages has a direct effect on system performance. Each time a system event is logged, a small performance hit occurs. Logging messages of type SEVERE affects the system the least whereas logging at the INFO level can cause the system to slow down due to the sheer volume of messages that are written to the log. The effect that the logging level has on XperienCentral performance is indicated as follows.
Indicator |
|
|
|
|---|---|---|---|
| Log level | SEVERE | WARNING | INFO |
To change the log level, follow these steps:
...