Is there a way to validate how long segmentation will take after adding nodes to a cluster in DX Netops 20.2.x Performance Management
search cancel

Is there a way to validate how long segmentation will take after adding nodes to a cluster in DX Netops 20.2.x Performance Management

book

Article ID: 206193

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Is there any way we can determine estimate time that it would take to perform the segmentation process in our environment? 

Environment

Release : 20.2

Component : CA Performance Center

Resolution

Unfortunately, this is environment specific, and the method of estimation is post-expansion:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/20-2/administrating/data-repository-administration/segment-database-tables.html#concept.dita_7e04ed2d9dbf6db53f8837e731b7a0038844225a_DeterminetheTableSegmentationTime

Additional Information

Note that there is no requirement to segment the tables right after the expansion.

The segmentation can reduce disk space and does seem to help with query performance.

You can do the expansion, then segment at a later time, and it does not need to` be done all at once.

You can segment while the DA is running (note the performance note in the guide).

You could do the option to create a script and then run each command in the produced script during off-hours until complete across multiple days.

So the segmentation can be done at a later time, over time, as needed.