Performance Statistics
Go Up to Requesting Information about an Attachment
There are four properties that provide performance statistics of a database. The statistics accumulate for a database from the moment the first process attaches to the database until the last remaining process detaches from the database. For example, the value that the Reads property returns the number of reads since the current database was first attached by any process. That number is an aggregate of all reads done by all attached processes and not the number of reads done by the process of the current program.
| Property | Returns |
|---|---|
|
|
The number of reads from the memory buffer cache as a long integer |
|
|
The number of writes to the memory buffer cache as a long integer |
|
|
The number of pages reads from the database since the current database was first attached; returned as a long integer |
|
|
The number of page writes to the current database since it was first attached by any process; returned as long integer |