Scenario
Nathan is a Capacity Planner in an IT organization. He manages and monitors all virtual machines in his organization to ensure that the existing infrastructure capacity has sufficient resources (CPU, memory, and storage) to meet the current and future demands.
Current problem: Nathan wants to know whether the capacity of all virtual machines is optimally and efficiently utilized. He wants to review the utilization of virtual machines that are deployed across all regions in his organization.
Solution: Nathan can use the custom view generated using the Data mart explorer template to quickly and easily get the information that he wants. On the custom view page, He can view and compare the capacity details for all virtual machines and identify the virtual machines that have capacity shortfall. He can easily export the page details to a PDF or a spreadsheet for offline analysis and reference.
Workflow
The following illustration provides a high-level view of the process.
Prerequisite tasks
Let us assume that Alan, the TrueSight Capacity Optimization administrator, has already completed the following prerequisite tasks:
- Identify the required metrics and entities (domain, systems and business drivers).
Configure the required ETL modules for collecting data from the required systems. For more information, see Overview of ETLs.
OR
Configure the Gateway Server and Capacity Agent and enable Auto-create ETLs option. For more information, see Managing and maintaining Gateway Servers and Collecting data via Capacity Agents.Note
The ETL modules or Auto-create ETLs automatically add the domain and associated entities to the workspace. Alternately, you can manually add the required domain and entities in the workspace. For more information, see Adding system and business driver entities to a domain.
Steps
1. Configure the required data mart
Alan performs the following steps to configure the data mart:
- Log on to the TrueSight Capacity Optimization console.
- Create a SQL-based data mart for extracting the details for the VMs capacity. Set the Purpose of data mart to Build Capacity View in TrueSight Console. For more information, see Creating a SQL-based data mart for a custom view in the TrueSight console.
Click here to view the sample query for creating data mart...
SELECT * FROM ER_V_EST_CAPACITY_HOUR_2037 where scenarioid = 80Consider the following example data mart:
| Ref_date | Region_name | VMs_capacity | VMs_consumed | VMs_reserved |
|---|---|---|---|---|
02/09/2018 00:00:00 | PUN | 700 | 350 | 200 |
02/09/2018 00:00:00 | AUS | 850 | 550 | 150 |
08/08/2018 00:00:00 | PUN | 750 | 450 | 100 |
08/08/2018 00:00:00 | PHX | 500 | 250 | 200 |
12/09/2018 00:00:00 | PUN | 800 | 400 | 100 |
12/09/2018 00:00:00 | AUS | 900 | 500 | 200 |
02/09/2018 00:00:00 | PHX | 600 | 350 | 100 |
12/09/2018 00:00:00 | PHX | 650 | 450 | 50 |
08/08/2018 00:00:00 | AUS | 800 | 450 | 50 |
2. Add and configure a custom view
Alan performs the following steps to add and configure the custom view:
- Log on to the TrueSight console.
- In the left navigation pane, click Administration > Capacity Views, and click Add View (Data mart explorer). For more information, see Adding a custom view.
- Add a view page (Virtual Machines Capacity by region) using the Data mart explorer template.
- Configure the chart settings as shown below:
- When you select any of the category chart templates, you can customize the metric legend and color displayed in a chart. Select a metric, and click the corresponding Customize link.
- (Optional): Configure the filters in the view pages according to the requirement. For more information, see Using filtering options in the TrueSight console.
- (Optional): Configure the rendering options in the view pages to add link to other pages in the view.
After the Data mart explorer view is configured, Alan grants the permissions required to use the view to Nathan. For more information, see Configuring users and user groups.
3. Use the custom view
Paul performs the following steps to use the Data mart explorer view (custom view):
- Log on to the TrueSight console.
In the left navigation pane, click Capacity > Views > Custom Views > Data mart explorer.
The Data mart explorer view is displayed.- To review the total, consumed, and reserved virtual machines across regions, select Virtual Machines Capacity by Region. On hovering the mouse over a section of a bar in the chart, you can view details of the virtual machines capacity.
- (Optional) On clicking a type in the legend, you can choose to remove the details for that type.
- Save a copy of the final results as a report for offline reference or to share it with other stakeholders.
