Capacity Planning Gadget

Capacity Planning Gadget v1.8

Allows you to view and estimate capacity metrics for:

• VMWare hosts and clusters
• Hyper-V hosts
• Xenserver hosts
• Agent / WMI collected hosts

Use your mouse cursor to hover over a point on the graph to view an exact metric.

Use the Capacity Buffer slider to gauge the level of capacity you want to use. For example, move the slider to 80% and the gadget calculates the metrics based on days left until that element reaches 80% capacity.

####Installation Instructions

• Uptime 7.3 and later - install via the Extension Manager
• Uptime 7.2 and earlier - Install using the Uptime Plugin Manager

Refresh the gadgets and pick Metric gadget in the list

For Oracle and MS-SQL users, please install the ODBC driver for your database on the Uptime monitoring station.

Following are some useful links and steps to install the drivers:

Note: If database and monitoring station are installed on same machine then drivers should already be installed. Only DSN will need to be created. Also, the exact name as specified above must be used for the connection or the gadgets will not work. If you wish to use a different connection name, you must edit the uptimeDB.php file accordingly.

####Oracle ODBC Driver Linux Install Steps:

1. Install unixODBC via your package manager (ie. yum install unixodbc) . This will install unixODBC into your ‘/usr/lib64/’ directory.
2. Download and Install the latest version of the ‘Oracle Instant Client Basic’ package, available from Oracle (http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html). Keep in mind that Uptime 7.2 comes bundled with 64bit Apache/PHP so you will need the Linux x86-64 package. ie. oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm . (The 12.1 package works with 11g Databases as well). This package will install some of the required binaries/drivers for Oracle into /usr/lib/oracle/12.1/client64/lib/
3. Download and install the ‘ ODBC: Additional libraries’ package from Oracle (ie. oracle-instantclient12.1-odbc-12.1.0.1.0-1.x86_64.rpm ). This provides the actual ODBC Driver we need from Oracle.

4. Edit the /etc/init.d/uptime_httpd script that starts Uptime’s apache, and add the following lines to set some of the required environment variables(This should be towards the beginning of the script add the end of to the other export commands ie. export PATH , export MIBDIRS etc).

   export ORACLE_HOME=/usr/lib/oracle/12.1/client64
   export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
   

5. Restart uptime_httpd service to pick up this change

   /etc/init.d/uptime_httpd stop
   /etc/init.d/uptime_httpd start
   

6. Make sure to uncomment one of the odbc driver lines in /gadgets/definitions/uptime.Metricgadget/uptimeDB.php as explained above.

####Oracle ODBC Driver Windows Install Steps:

1. Install the Oracle Instant Client drivers or have the Oracle Client installed on the monitoring station. To get the Instant Client Download for Oracle, download the 64 bit drivers:

   http://www.oracle.com/technetwork/database/features/instant-client/index.html

   ie. instantclient-basic-windows.x64-12.1.0.1.0.zip

2. Create a new directory C:\Oracle. Unzip the downloaded file into the new directory. You should now have C:\Oracle\instantclient_12_1 which contains a bunch of .dll & .sym files.

3. Download the ‘Instant Client Package - ODBC’ from the same page above. ie. instantclient-odbc-windows.x64-12.1.0.1.0.zip . Extract this zip into the same C:\Oracle\instantclient_12_1 path.

4. Open a command prompt in the C:\Oracle\instantclient_12_1 directory and run the odbc_install.exe which will install the Oracle ODBC drivers and setup the required Environment variables.

5. Run the ‘Data Sources (ODBC)’ utility from the Windows ‘Administrative Tools’. Click on the ‘Drivers’ tab, and confirm that you have an ‘Oracle in instantclient’ driver listed, and note the name of the driver, as this is required as the ‘ODBC Driver Name’ when setting up the service monitor. (Likely it will be ‘Oracle in instantclient_12_1’ or ‘Oracle in OraClient12Home1’).

6. Update the Path Environment Variable to include the path to the oracle driver. Append “;C:\Oracle\instantclient_12_1” to end of the variable. To set this variable Go to System Properties > Advanced > Environment Variables > Under System variables find Path and edit it.

7. Make sure to uncomment one of the odbc driver lines in /gadgets/definitions/uptime.Metricgadget/uptimeDB.php as explained above.

If your having trouble with installing just the Oracle InstantClient & ODBC the likely issue is you are missing “Microsoft Visual C++ 2010 SP1 Redistributable Package (x64)” package that has the DLL that this driver needs, another option is to install these drivers as part of the ‘Oracle Data Access Components’ which is a bundle of Oracle drivers full fleged installer compared to the zips mentioned above. This bundle can be found on the Oracle website here: http://www.oracle.com/technetwork/database/windows/downloads/index.html

###Additional MSSQL/SQLServer Install Steps:

In order to use the Metric gadget gadget with a SQLServer based Datastore, you will need to uncomment the appropriate ODBC Driver in uptime_dir/gadgets/definitions/uptime.Metricgadget/uptimeDB.php

Windows Based monitoring stations will already have ODBC itself installed as part of Windows, and should be able to use the example provided in uptimeDB.php.

Linux based monitoring stations will require the unixODBC package to be installed. This package should include the /usr/lib64/libtdsodbc.so.0 SQLServer ODBC Driver needed for MSSQL/SQLserver. Which is also the example provided in uptimeDB.php

See step #1 of ‘Oracle ODBC Driver Linux Install Steps:’ above for more details on installing unixODBC