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	DeclaredBlockSize	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.