A.4 Charts and Formulas

A.4.1 Chart Data

The five-minute data collected as described in Section A.3, Data Collection is stored in the database for thirty days. The one-hour data is a summary of all the five-minute data collected during a particular hour. It is stored permanently in the database. All other chart data is calculated from the five-minute and one-hour data.

The twenty-four hour profile chart provides a value for each hour in a twenty-four hour period. This value is the largest average value calculated for the particular hour over the selected date range. This produces a utilization profile for the hourCounter.

Counter values are named for the Windows Performance Monitor counters used to retrieve them from Windows systems. The name consists of the Performance Monitor category joined by an underscore to the counter name. For example, Memory/PagesPerSecond becomes Memory_PagesPerSecond.

For Windows systems, these values are taken directly from Performance Monitor, but for other platforms, scripts are used to calculate the values.

Table A-1 Platform Counters

Name

Platforms

LogicalDisk_FreeMegabytes

Windows

LogicalDisk_PercentFreeSpace

Windows

Memory_AvailableBytes

Windows, Windows NT, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

Memory_PagesPerSecond

Windows, Windows NT

Memory_PercentAvailableMemory

ESX 3.x, ESX 4

NetworkInterface_BytesTotalPerSecond

Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

NetworkInterface_PacketsPerSecond

Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

PhysicalDisk_CurrentDiskQueueLength

Windows, Windows NT, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

PhysicalDisk_DiskBytesPerSecond

Windows, Windows NT, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

PhysicalDisk_DiskTransfersPerSecond

Windows, Windows NT, Linux, ESX 2.5.x

PhysicalDisk_DiskWriteBytesPerSecond

Windows

PhysicalDisk_PercentIdleTime

Windows

Processor_PercentProcessorTime

Windows, Windows NT, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

System_ProcessorQueueLength

Windows, Windows NT, Solaris, Linux, ESX 2.5.x

VC_Processor

All

VC_ProcessorTime

All

VC_MemoryPercentAvailable

All

VC_MemoryAvailableBytes

All

VC_NetBytesTotalPerSecond

All

VC_NetPacketsPerSecond

All

VC_DiskBytesPerSecond

All

A.4.2 Utilization

Utilization formulas represent the percentage of the available resources being used by a given workload. The calculations are based on counter and inventory data.

Table A-2 Utilization Formulas

Name

Formula

Platforms

Disk IO (%)

MAX(0,(100-PERF("PhysicalDisk_PercentIdleTime")))

Windows

Disk Space Free (%)

100*(INV("FreeDiskSpace"))/INV("TotalDiskSpace")

Windows,Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

Disk Space Used (%)

100*(INV("TotalDiskSpace")-INV("FreeDiskSpace"))/INV("TotalDiskSpace")

Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

Memory Free (%)

100*(PERF("Memory_AvailableBytes"))/INV("TotalMemory")

Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

Memory Used (%)

100*(INV("TotalMemory")-PERF("Memory_AvailableBytes"))/INV("TotalMemory")

Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

Processor (%)

PERF("Processor_PercentProcessorTime")

Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

VC_MemoryFree (%)

100*(PERF("Memory_AvailableBytes"))/INV("TotalMemory")

All

VC_MemoryUsed (%)

100*(INV("TotalMemory")-PERF("Memory_AvailableBytes"))/INV("TotalMemory")

All

VC_ProcessorTime (Hour)

PERF(“VC_ProcessorTime”)

All

A.4.3 Workload

Workload formulas measure workload size; that is, the amount of processing power and raw resources being used for a workload, independent of the total hardware and resources available.

  • PERF: Dynamic performance data

  • INV:Static inventory data

    Table A-3 Workload Formulas

    Name

    Formula

    Platforms

    Disk (MB/sec)

    (PERF("PhysicalDisk_DiskBytesPerSecond"))/(1024*1024)

    All

    Disk (Transfers/sec)

    PERF("PhysicalDisk_DiskTransfersPerSecond")

    Windows, Windows NT, Solaris, Linux, ESX 2.5.x

    Disk Queue Length

    PERF("PhysicalDisk_CurrentDiskQueueLength")

    Windows, Windows NT, Solaris, Linux, ESX 2.5.x

    Disk Space Free (GB)

    INV("FreeDiskSpace")/(1024*1024*1024)

    All

    Disk Space Used (GB)

    (INV("TotalDiskSpace")-INV("FreeDiskSpace"))/(1024*1024*1024)

    All

    Disk Writes (MB/sec)

    (PERF("PhysicalDisk_DiskWriteBytesPerSecond"))/(1024*1024)

    Windows

    Memory (Pages/sec)

    PERF("Memory_PagesPerSecond")

    Windows, Windows NT

    Memory Free (MB)

    (PERF("Memory_AvailableBytes")) /(1024*1024)

    All

    Memory Used (MB)

    (INV("TotalMemory")-PERF("Memory_AvailableBytes")) /(1024*1024)

    All

    Network (MB/sec)

    (PERF("NetworkInterface_BytesTotalPerSecond"))/(1024*1024)

    Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x

    Network (Packets/sec)

    PERF("NetworkInterface_PacketsPerSecond")

    Windows, Solaris, Linux, ESX 2.5.x, ESX 3.x, ESX 4

    Processor (MHz)

    PERF("Processor_PercentProcessorTime")*INV("ProcessorCapacity")/100

    Windows, Windows NT, Linux, ESX 2.5.x, ESX 3.x, ESX 4

    Processor Queue Length

    PERF("System_ProcessorQueueLength")

    Windows, Windows NT, Solaris, Linux, ESX 2.5.x

    VC_Disk (MB/sec)

    (PERF("PhysicalDisk_DiskBytesPerSecond"))/(1024*1024)

    All

    VC_MemoryFree (MB)

    (PERF("Memory_AvailableBytes")) /(1024*1024)

    All

    VC_MemoryUsed (MB)

    (INV("TotalMemory")-PERF("Memory_AvailableBytes")) /(1024*1024)

    All

    VC_Network (MB/sec)

    (PERF("NetworkInterface_BytesTotalPerSecond"))/(1024*1024)

    All

    VC_Network (Packets/sec)

    PERF("NetworkInterface_PacketsPerSecond")

    All

    VC_Processor (MHz)

    PERF("Processor_PercentProcessorTime")*INV("ProcessorCapacity")/100

    All