|
This Excel® automation is loading, normalizing, cleaning, marking and beautifying a Uniface Profiling log file.
|
|
User interface is quite simple: it is requested to:
|
|
- Define the full path name of your Uniface profiling log file.
|
|
- Define the separator configured in your ASN to generate your Uniface profiling log file: <Gold>Sep, semicolon, colon, tab, space. It should be automatically recognized from this version onwards.
|
|
- Minimum time level in millisec to be used to put evidence on lines (marking).
|
|
- Which values user wants to check to mark: by default comparing minimum time level defined with "DBMStime/NetworkTime/ComputeTime" or choosing to consider also ElapsedTime and IdleTime with "AllTimeValues". Rows with at least one _X time larger than the user selected value in millisec are marked red or yellow; red ones are more critical and should be analized/tuned first.
|
|
This automation was tested with version 2003 32bit and 2016 64bit using Uniface profiling logs file up to 50k rows; it should be sufficient for most cases, making sure to reduce the Uniface profiling log file to the smallest possible size.
|
|
This latest version is extended to manage profiling log file including Uniface Servers usage and calculating ComputeTime columns.
|
|
Please send any remark or suggestion to gianni.sandigliano@unifacesolutions.com.
|
|
This automation is published in public domain recalling a colleague with whom I discussed this feature a few days before he left this life. Ciao Gep! (Giuseppe Enrico)
|
