AseRep_ASEFrag

Fragmentation statistics

This page looks like :

Conditions to get info in this page :

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)

How does the collector work

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)

Usage of this page

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 :

• 0 - all rows having or not a severity warning
• 1 - all rows having at least a severity of 1 (one yellow mark)
• 2 - all rows having at least a severity of 2 (one red mark)

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]