# ESB_DBSTATS_T

This database Statistics Structure returns run-time statistical information about a specific database. Fields in this structure cannot be modified using the VB API. See also the ESB_DBSTATE_T structure, which contains additional database state parameters that can be modified, and the ESB_DBINFO_Tstructure. The fields are:

    Type ESB_DBSTATS_T

       nDims                   As Long
       DeclaredBlockSize       As Long
       ActualBlockSize         As Long
       DeclaredMaxBlocks       As Double
       ActualMaxBlocks         As Double
       NonMissingLeafBlocks    As Double
       NonMissingNonLeafBlocks As Double
       NonMissingBlocks        As Double
       PagedOutBlocks          As Double
       PagedInBlocks           As Double
       InMemCompBlocks         As Double
       TotalBlocks             As Double
       NonExclusiveLockCount   As Double
       ExclusiveLockCount      As Double
       TotMemPagedInBlocks     As Double
       TotMemBlocks            As Double
       TotMemIndex             As Double
       TotMemInMemCompBlocks   As Double
       BlockDensity            As Double
       SparseDensity           As Double
       CompressionRatio        As Double
       IndexType               As Integer
       ClusterRatio;           As Double
    End Type

VB Data Type | Field | Description
As Integer | IndexType | The database index type (array or tree). This field can contain the following values: ESB_INDEXTYPE_ARRAY ESB_INDEXTYPE_AVL
As Long | nDims | Number of dimensions
As Long | DeclaredBlock Size | The declared data block size
As Long | ActualBlockSize | The actual data block size
As Double | DeclaredMax Blocks | The declared maximum number of blocks in the database
As Double | ActualMaxBlocks | The actual maximum number of blocks in the database
As Double | NonMissingLeaf Blocks | The number of non-missing leaf (lowest level) blocks in the database
As Double | NonMissingNon LeafBlocks | The number of non-missing, non-leaf (upper level) blocks in the database
As Double | NonMissing Blocks | The total number of non-missing blocks in the database
As Double | PagedOutBlocks | The number of database blocks currently paged out to disk
As Double | PagedInBlocks | The total number of database blocks currently paged into memory
As Double | TotalBlocks | Total number of existing data blocks (not the maximum)
As Double | NonExclusive LockCount | The number of database blocks currently non-exclusively locked
As Double | ExclusiveLock Count | The number of database blocks currently exclusively locked
As Double | TotMemBlocks | The total memory used for all database blocks
As Double | TotMemIndex | The total memory used for the database index
As Double | TotMemPagedIn Blocks | The total memory used for all paged-in (uncompressed) database blocks
As Double | BlockDensity | The average database block density (calculated using all currently loaded blocks)
As Double | SparseDensity | Average density of the sparse dimensions in the database
As Double | CompressionRatio | Average data block compression ratio on the disk
As Double | InMemCompBlocks | The number of database blocks currently paged into compressed memory
As Double | TotMemInMemCompBlocks | The total memory used for database blocks currently paged into compressed memory
As Double | ClusterRatio | A measure of the fragmentation of the page file. A value close to 1 indicates the degree of fragmentation is low. A value close to zero indicates a high degree of fragmentation that could affect calculation and query performance.