|Evaluating Statistics for the System and Applications / Using VSD to Analyze Statistics|
With statement-level statistics enabled, statistics are available for all DML statements.
An example follows the table.
|Name||INSERT<dml>, SELECT<dml>, UPDATE<dml>, DELETE<dml>|
|Description||The number of times that a statement was executed.|
This VSD chart shows statistics for two fabric servers for prepared statements that insert rows in the history table. The first round of inserts occurs during initial data loading. The second round occurs as part of normal business operations. This chart also shows that the application used different prepared statements for data loading and subsequent transactions, with slightly different ordering in the fields. If the statements had been identical, there would be only one instance per server.