Example Database Summary

The following Database Collection was made using the NtMemory (NTMEMORY) record over a 5-minute collection interval and started at 08.20.

Time

Node Name

MB Free

CachMB

FREE MB%

08.25

\NODE_A

518.76

140.42

84.00

08.30

\NODE_A

514.46

142.79

84.02/p>

08.35

\NODE_A

513.88

142.82

84.02

08.40

\NODE_A

512.76

142.81

83.97

08.45

\NODE_A

511.50

143.93

83.97

08.50

\NODE_A

510.92

143.57

83.93

08.55

\NODE_A

506.23

144.12

83.78

The following Database Summary was then run using a 30-minute interval. The average summary values were requested for the MB FREE, CACH MB and FREE MB% fields. In addition the maximum value was requested for the MB FREE field and the minimum value for the FREE MB% field.

Time

Node Name

MB Fee

MB Free MAX

CACH MB

FREE MB%

FREE MB % MIN

08.00

\NODE_A

518.76

518.76

140.42

84.00

84.00

08.30

\NODE_A

511.62

514.46

143.34

83.94

83.78

The Database Summary starts at 08.00 and includes only the data collected by the Database Collection between the period 08.00 and 08.30, this being only the one line of data collected at 8.25.

In the next summary interval at 08.30 all data collected between 08.30 and 09.00 is summarized as follows:

Time

Node Name

MB Free

CachMB

FREE MB%

08.30

\NODE_A

514.46

142.79

84.02

08.35

\NODE_A

513.88

142.82

84.02

08.40

\NODE_A

512.76

142.81

83.97

08.45

\NODE_A

511.50

143.93

83.97

08.50

\NODE_A

510.92

143.57

83.93

08.55

\NODE_A

506.23

144.12

83.78

Total of 6 intervals

3069.75

860.04

503.69

Divided by 6 intervals

511.62

143.34

83.94

The Database Summary calculates the average amounts for the MB FREE (511.62), CACH MB (143.34) and FREE MB% (83.94) fields over the 6 collection intervals and also collects the maximum MB FREE (514.46) and minimum FREE MB% (83.94) values.

Provide feedback on this article