This page looks like :
The "Fragment.xml" or "Fragment_V15.xml" must be set in your config.xml file.
No specific configuration needed on ASE monitored server.
By default the "Fragment" collector collects data one time per day (delay=86400)
You can define when this collection should happen using the "HOUR_EXEC" attribute. Ex. in your config file :
<md hour_exec="7" minpages="1000"> Fragment.xml </md>
With this configuration the fragmentation of objects (table or index) bigger than 1000 pages will be collected one time everyday between 7 and 7:59 (exact time depends on the time asemon_logger started)
This collector collects data for all databases in the server (except tempdb, user created tempdb, proxy db, archive db, db with special status like "in recovery", "suspect", ...
Data collected comes from systabstats, sysobjects, sysindexes and "derived_stats" functions
(Functions like data_pages and reserved_pages, returning exact info, are not used because they can be very long to execute on large tables, so data returned from this collector depends on accuracy of statistics on tables)
By default when you call this page the last collection of fragmentation data for the analysed period (the "From" and "To" fields in the main screen) is displayed.
If during the analyzed period (say several days) it exists several collections of data, you can choose the wanted data in the "'''Date of fragmentation analysis'''" select list.
You can choose to display data for object of a minimum given size, using the field : "'''Min pagecnt or leafcnt'''"
By default only object with a "severity" of 2 are displayed. With the "'''Show minimum level'''" field you can display :
YELLOW mark means not severe fragmentation
RED mak means severe fragmentation
Fragmentation thresholds are hard coded in the PHP page :
< 0.5 for a cluster ratio means severe fragmentation
> 0.5 and < 0.8 for a cluster ratio means no severe fragmentation
> 0.8 means no fragmentation
Return to Asemon_report main documentation page [Asemon_report documentation]