This section includes the following topics:
This user’s guide is divided into 3 sections:
The introduction section provides general information about the product, terms used, and features used in both Oracle and MS-SQL-based portlets.
The fields in which you have to enter information are case sensitive. |
The following table describes some often used terms:
The Precise Custom Portal will be used for the UI presentation of the data. The portlets for showing the simulated data placed on a new page (tab) are:
Additionally a Settings page is also shown.
The Precise Business Storage Optimizer portlets show the impact percentage of improvement in terms of Total Response Time. This percentage may have a deviation of up to 10%.
There are two users defined in the Precise Business Storage Optimizer with the following rights:
Table 1 Defined users
User | Password | Rights |
---|---|---|
simulator | simulator | View rights on all screens. |
simulatoradm | simulatoradm | Also edit right in the Settings screen. |
The Settings page provides four groups of fields that are used to define what information is displayed.
Table 2 Connectivity Parameter fields
Field | Description |
---|---|
Monitored database technology | The type of technology that is used (Oracle or MS-SQL). |
Precise application | The name of the Precise application. |
Precise Tier | The type of Tier that is used. |
Table 3 Display field
Field | Description |
---|---|
Maximum number of presented rows | The maximum number of rows presented in all tables throughout the product. |
Table 4 Device Cost Parameter fields
Field | Description |
---|---|
Currency | The currency used for the cost of the devices. |
Cost of 1GB of EFD | Cost of 1GB of storage on an EFD device. |
Cost of 1GB of FC | Cost of 1GB of storage on an FC device. |
Cost of 1GB of SATA | Cost of 1GB of storage on a SATA device. |
If one of the values is zero (0), then the recommended ranking will be based on performance only. |
Table 5 Ranking Threshold Parameter fields
Field | Description | |
---|---|---|
High performance improvement | Enter the recommended ranking threshold parameter in percentage for a high performance improvement.
| |
Medium performance improvement | Enter the recommended ranking threshold parameter in percentage for a medium performance improvement.
| |
Low performance improvement | Enter the recommended ranking threshold parameter in percentage for a low performance improvement.
| |
Low performance deterioration | Enter the recommended ranking threshold parameter in percentage for a low performance deterioration.
| |
Medium performance deterioration | Enter the recommended ranking threshold parameter in percentage for a medium performance deterioration.
| |
High performance deterioration | Enter the recommended ranking threshold parameter in percentage for a high performance deterioration.
| |
Help button | Provides context sensitive help. | |
Back button | Return to the previous screen. | |
Next button | Go to the next screen. | |
Close button | A warning message is displayed. If you confirm the cancellation, the Configuration wizard is closed and your previous changes are saved. Next time you start the Configuration wizard you will see the changes you have already made and can click on Next until you advance to where you left off. |
The following tables show the default parameters for the Ranking Thresholds. The tables are followed by examples:
Table 6 Performance improvement
Level | Value |
---|---|
High performance improvements | 60% |
Medium performance improvements | 45% |
Low performance improvements | 30% |
Table 7 Performance deterioration
Level | Value |
---|---|
Low performance deterioration | 6% |
Medium performance deterioration | 12% |
High performance deterioration | 20% |
The following are examples based on the default thresholds in the above tables.
If the performance of a statement on an FC device is 1 hour and you simulate this statement on an EFD device, the performance improvement can be calculated. Based on the calculated value, the performance improvement can be for example 47%. This means that the performance improvement is medium. If you simulate this statement on a SATA device, there can be a deterioration of the performance of 7% and this is than low. This level of deterioration can be acceptable.
If the performance of a statement on an FC device is 1 hour and you simulate this statement on an EFD device, the performance improvement can be calculated. Based on the calculated value, the performance improvement can be for example 20%. This means that the performance improvement is lower than the set threshold, which means that the optimizer will not recommend to move the entity to an EFD device.
To select the desired Time Frame, do one of the following
By default, a ‘last day’ time frame is selected.
The Simulate button is used to refresh the data in the tables of the portlet or apply the changes that have been made in the settings for that portlet (for example a change Target Device Type in the Transaction page).
The Recommend button is used to refresh the data in the tables of the Recommendation page or apply the changes that have been made in the settings for that page (for example a change from Objects to Data files).