public bool statsTests(
string sDbName,
DbSystem dbSystem)
{
Db db = null;
DbSystemStats stats = null;
uint uiNumDatabases;
uint uiStartTime;
uint uiStopTime;
CS_XFLM_DB_STATS dbStats = null;
CS_XFLM_LFILE_STATS lFileStats = null;
beginTest( "Start statistics");
try
{
dbSystem.startStats();
}
catch (XFlaimException ex)
{
endTest( false, ex, "starting statistics");
return( false);
}
endTest( false, true);
// Open a database to make some statistics happen
beginTest( "Open Database Test (" + sDbName + ")");
try
{
db = dbSystem.dbOpen( sDbName, null, null, null, false);
}
catch (XFlaimException ex)
{
endTest( false, ex, "opening database");
return( false);
}
if (db != null)
{
db.close();
db = null;
}
endTest( false, true);
// Stop collecting statistics
beginTest( "Stop statistics");
try
{
dbSystem.stopStats();
}
catch (XFlaimException ex)
{
endTest( false, ex, "stopping statistics");
return( false);
}
endTest( false, true);
// Get statistics
beginTest( "Get statistics");
try
{
stats = dbSystem.getStats();
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting statistics");
return( false);
}
endTest( false, true);
// Get general statistics
beginTest( "Get general statistics");
try
{
stats.getGeneralStats( out uiNumDatabases, out uiStartTime,
out uiStopTime);
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting statistics");
return( false);
}
endTest( false, true);
printUIntStat( 0, "Databases", uiNumDatabases);
printUIntStat( 0, "Start Time", uiStartTime);
printUIntStat( 0, "Stop Time", uiStopTime);
// Get Database statistics
for (uint uiLoop = 0; uiLoop < uiNumDatabases; uiLoop++)
{
beginTest( "Get database statistics for DB#" + uiLoop);
try
{
dbStats = stats.getDbStats( uiLoop, dbStats);
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting database statistics");
return( false);
}
endTest( false, true);
printStrStat( 0, "Database Name", dbStats.sDbName);
printUIntStat( 0, "Logical File Count", dbStats.uiNumLFiles);
System.Console.WriteLine( "Read Transactions");
printCountTimeStat( 1, "Committed Transactions", dbStats.ReadTransStats.CommittedTrans);
printCountTimeStat( 1, "Aborted Transactions", dbStats.ReadTransStats.AbortedTrans);
System.Console.WriteLine( "Update Transactions");
printCountTimeStat( 1, "Committed Transactions", dbStats.UpdateTransStats.CommittedTrans);
printCountTimeStat( 1, "Aborted Transactions", dbStats.UpdateTransStats.AbortedTrans);
printCountTimeStat( 1, "Group Completes", dbStats.UpdateTransStats.GroupCompletes);
printULongStat( 1, "Group Finished", dbStats.UpdateTransStats.ulGroupFinished);
printBlockIOStats( 0, "LFH Block Stats", dbStats.LFHBlockStats);
printBlockIOStats( 0, "Avail Block Stats", dbStats.AvailBlockStats);
printDiskIOStats( 0, "Database Header Writes", dbStats.DbHdrWrites);
printDiskIOStats( 0, "Log Block Writes", dbStats.LogBlockWrites);
printDiskIOStats( 0, "Log Block Restores", dbStats.LogBlockRestores);
printDiskIOStats( 0, "Log Block Reads", dbStats.LogBlockReads);
printUIntStat( 0, "Log Block Checksum Errors", dbStats.uiLogBlockChkErrs);
printUIntStat( 0, "Read Errors", dbStats.uiReadErrors);
printCountTimeStat( 0, "No Locks", dbStats.LockStats.NoLocks);
printCountTimeStat( 0, "Waiting For Lock", dbStats.LockStats.WaitingForLock);
printCountTimeStat( 0, "Held Lock", dbStats.LockStats.HeldLock);
for (uint uiLoop2 = 0; uiLoop2 < dbStats.uiNumLFiles; uiLoop2++)
{
beginTest( " Get database statistics for DB#" + uiLoop + ", LFile#" + uiLoop2);
try
{
lFileStats = stats.getLFileStats( uiLoop, uiLoop2, lFileStats);
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting logical file statistics");
return( false);
}
endTest( false, true);
System.Console.WriteLine( " LOGICAL FILE {0} ({1})",
lFileStats.uiLFileNum, lFileStats.eLfType);
printBlockIOStats( 2, "Root Block Stats", lFileStats.RootBlockStats);
printBlockIOStats( 2, "Middle Block Stats", lFileStats.MiddleBlockStats);
printBlockIOStats( 2, "Leaf Block Stats", lFileStats.LeafBlockStats);
printULongStat( 2, "Block Splits", lFileStats.ulBlockSplits);
printULongStat( 2, "Block Combines", lFileStats.ulBlockCombines);
}
}
return( true);
}
