ホーム › System.Search › SQLPERF
SQLPERF
構造体サイズ=各フィールドのバイト数(x64/x86 で異なる場合は x64/x86 と併記)。x64/x86 列=フィールドのバイトオフセット(HSPで dupptr / lpoke / wpoke 等に使用)。
フィールド
| フィールド | 型 | サイズ | x64 | x86 |
|---|---|---|---|---|
| TimerResolution | DWORD | 4 | +0 | +0 |
| SQLidu | DWORD | 4 | +4 | +4 |
| SQLiduRows | DWORD | 4 | +8 | +8 |
| SQLSelects | DWORD | 4 | +12 | +12 |
| SQLSelectRows | DWORD | 4 | +16 | +16 |
| Transactions | DWORD | 4 | +20 | +20 |
| SQLPrepares | DWORD | 4 | +24 | +24 |
| ExecDirects | DWORD | 4 | +28 | +28 |
| SQLExecutes | DWORD | 4 | +32 | +32 |
| CursorOpens | DWORD | 4 | +36 | +36 |
| CursorSize | DWORD | 4 | +40 | +40 |
| CursorUsed | DWORD | 4 | +44 | +44 |
| PercentCursorUsed | DOUBLE | 8 | +48 | +48 |
| AvgFetchTime | DOUBLE | 8 | +56 | +56 |
| AvgCursorSize | DOUBLE | 8 | +64 | +64 |
| AvgCursorUsed | DOUBLE | 8 | +72 | +72 |
| SQLFetchTime | DWORD | 4 | +80 | +80 |
| SQLFetchCount | DWORD | 4 | +84 | +84 |
| CurrentStmtCount | DWORD | 4 | +88 | +88 |
| MaxOpenStmt | DWORD | 4 | +92 | +92 |
| SumOpenStmt | DWORD | 4 | +96 | +96 |
| CurrentConnectionCount | DWORD | 4 | +100 | +100 |
| MaxConnectionsOpened | DWORD | 4 | +104 | +104 |
| SumConnectionsOpened | DWORD | 4 | +108 | +108 |
| SumConnectiontime | DWORD | 4 | +112 | +112 |
| AvgTimeOpened | DOUBLE | 8 | +120 | +120 |
| ServerRndTrips | DWORD | 4 | +128 | +128 |
| BuffersSent | DWORD | 4 | +132 | +132 |
| BuffersRec | DWORD | 4 | +136 | +136 |
| BytesSent | DWORD | 4 | +140 | +140 |
| BytesRec | DWORD | 4 | +144 | +144 |
| msExecutionTime | DWORD | 4 | +148 | +148 |
| msNetWorkServerTime | DWORD | 4 | +152 | +152 |