How do I collect data for charting the growth rate of SQL databases without raising events? (NETIQKB5470)

  • 7705470
  • 02-Feb-2007
  • 01-Oct-2010

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
SQL_DBGrowthRate Knowledge Script

Situation

How do I collect data for charting the growth rate of SQL databases without raising events?

Resolution

To configure the SQL_DBGrowthRate knowledge script to only collect data for the Growth Rate and to not generate any Events, set the following parameters:

  • Raise an event if rate exceeds threshold?: Set to n; this indicates Events will not be generated if the threshold is exceeded.
  • Raise an event if database is off line?:  Set to n; this indicates that no event will be generated even if the database is offline.
  • Collect Data for database growth and shrinkage rates?: Set to y; this indicates Data will be collected for each iteration.
  • Threshold -- Maximum percentage of database growth: Set to a specified percentage; this percentage is the threshold.
  • Threshold -- Maximum percentage of database shrinkage: Set to 0 (zero); this indicates that this value will be ignored.

Growth and shrink rates are calculated by taking the difference of the database space utilization from the current interval from the database space utilization from the last interval. If these rates exceed the thresholds set, an Event is raised.

Additional Information

Formerly known as NETIQKB5470