This section includes the following topics:
- About the Precise Business Storage Optimizer users guide
- About common terms used in this manual
- About Precise Business Storage Optimizer portlets in the Precise Custom Portal
- About the Settings page
- About Time Frame selection
- About the Simulate button
- About the Recommend button
About the Precise Business Storage Optimizer users guide
This user’s guide is divided into 3 sections:
- Introduction
- About the Oracle-based Precise Business Storage Optimizer portlets
- About the MS-SQL-based Precise Business Storage Optimizer portlets
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.
About common terms used in this manual
The following table describes some often used terms:
- Time In Oracle. The total consumption time that the statement/program spent in the Oracle database.
- Time In MS-SQL. The total consumption time that the statement/program spent in the MS-SQL database.
- I/O Time. The total time that the statement/program was waiting for I/O.
- EFD. Enterprise Flash Drive.
- FC. Fiber Channel (15K).
- SATA. Serial ATA Drive.
- Ranking. Ranking Indicator.
About Precise Business Storage Optimizer portlets in the Precise Custom Portal
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:
- Tiering Recommendations
- Transactions
- User
- Database
- Storage Device
- FAST Integration
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%.
About the users in the Precise Business Storage Optimizer
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. |
About the Settings page
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. When the default value is 60 and the calculated value is 60 or higher, the performance improvement is high. |
| Medium performance improvement | Enter the recommended ranking threshold parameter in percentage for a medium performance improvement. When the default value is 45 and the calculated value is between 45 and 60, the performance improvement is medium. |
| Low performance improvement | Enter the recommended ranking threshold parameter in percentage for a low performance improvement. When the default value is 30 and the calculated value is between 30 and 45, the performance improvement is low. |
| Low performance deterioration | Enter the recommended ranking threshold parameter in percentage for a low performance deterioration. When the default value is 6 and the calculated value is between 6 and 12, the performance deterioration is low. |
| Medium performance deterioration | Enter the recommended ranking threshold parameter in percentage for a medium performance deterioration. When the default value is 12 and the calculated value is between 12 and 20, the performance deterioration is medium. |
| High performance deterioration | Enter the recommended ranking threshold parameter in percentage for a high performance deterioration. When the default value is 20 and the calculated value is between 20 and higher, the performance deterioration is high. |
| 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.
About Time Frame selection
To select the desired Time Frame, do one of the following
- On the Time Frame pane, select one of the pre-defined time frames (i.e., 6h, 1d, 2d, 1w, or 2w) OR
- On the Time Frame pane, click the currently selected time frame or the down arrow and on the displayed dialog box either:
- Click the ‘Last:’ option and enter the number of Min, Hrs, Days, Weeks, or Months to use as your time frame. Click OK.
OR - Click the ‘From:’ option and select the beginning and ending date and time to use as your time frame. Click OK.
- Click the ‘Last:’ option and enter the number of Min, Hrs, Days, Weeks, or Months to use as your time frame. Click OK.
By default, a ‘last day’ time frame is selected.
About the Simulate button
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).
About the Recommend button
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).