| Info |
|---|
Information only for AppDynamics users BW Analysis execution is not within the scope of AppDynamics ABAP Agent monitoring. This analysis will be soon not delivered with Insights by default but will need to be installed as a standalone functionality. You might find more details about BW Analysis in chapter (DI-2108) Set up BW Analysis. It is not recommended to setup this analysis without additional knowledge as it is a time-consuming operation and can decrease the performance of the system. |
There are additional prerequisites for enabling BW analysis depending on the system type:
...
Step | Details |
|---|---|
Go to transaction /DVD/QS_CONF | |
The screen for setting up configuration is displayed. |
Insights Extended Query statistics configuration screen |
Click on the 'ON' radio button for 'Query statistics enabled' to turn the collection of statistics on. User information collected can be turned on optionally (If this setting is turned on, the information about which user executed the query is captured). | |
| Confirm the change of configuration by clicking on the 'Save Config' button (or using the F8 key). | |
| A confirmation dialog is displayed. |
Change the configuration confirmation dialog |
| Click on the 'Yes' button to confirm the change of configuration. |
...
Click on the 'Select InfoProviders' button. A dialog window is displayed where you can restrict for which InfoProviders should be statistics collected. If no InfoProviders are specified in the table (initial state), statistics will be collected for the whole system. You can always disable collecting statistics for specific InfoProvider by deselecting the 'Enabled' column or removing them from the list. It is important to note that once the InfoProvider selection is used, statistics will be collected only for those with the "Enabled" flag one. For not specified InfoProviders in the list, statistics won't be collected.
Restrict query statistics collection
Click on the "Exclude characteristics" button to display the select option for characteristics exclusion. In this window, you can define which characteristic filter values should not be saved when queries are executed. This option should be used only when necessary to reduce the amount of data saved in the statistics table (useful for huge hierarchy selections) as it reduces the completeness of statistics.
Excluding characteristics from collection
Scheduling of statistics collection
It is possible to schedule enabling statistics on a regular basis if requested. For this purpose report '/DVD/QS_CONFIG_SCHEDUL' (transaction /DVD/QS_SCHED) is provided. You can create two standard report variants for this report.
Scheduling of DVD extended query statistics collection
In the first variant, you specify the checkbox as checked while in the second variant this checkbox would be unchecked. You can then schedule the execution of this report with the first variant every morning through a standard SAP report scheduling functionality. This would cause statistics collection to be turned on every morning. Then you would schedule the execution of this report with the second variant every midnight to turn off the statistics collection.
...
- Go to transaction RSRT and choose random Query with filtering options.
- Click on the 'Execute + Debug' button to display query execution options.
- In the list of settings check the checkbox next to the 'Do Not Use Cache' option.
Do not use the cache query execution option
4. Click on Continue (or use Enter Key) to execute the query (in the next screen that is query dependent, fill at least one filter).
...
6. Insert the following table name '/DVD/QS_QINFO' and click on the 'Table contents' button (F7).
DVD extended query statistics main table
7. Do not use any filters and click on the 'Execute' button (F8).
8. In the following screen with a table content you should see at least one row with the information about the query just executed through the RSRT transaction.
Captured information about the executed query
9. Go back to transaction SE16. Fill in table name '/DVD/QS_QVAR' and click on the 'Table contents' button (F7).
DVD extended query statistics filter table
10. Do not use any filters and click on the 'Execute' button (F8).
11. In the following screen with a table content you should see at least one row with the information about the used filter in the executed query (if you chose such query with filters and specified some).
Captured filtering information
If any information is captured after DVD statistics were enabled in the system and the query was executed, the validation is done.