Analysis Services
Analysis Server:Query Object
The following table lists performance counters from the Microsoft® SQL Server™ 2000 Analysis Services Query object. The Query object counters provide information about processing on the last query, such as elapsed time in milliseconds of the last query processed.
| Query object counters | Description |
|---|---|
| Avg time/query | Average time per query in milliseconds. This counter is based on queries answered since the last counter measurement. |
| Bytes sent/sec | Count of bytes sent per second. |
| Current process thread pool | Current count of threads in processing threads pool. These threads resolve queries. |
| Current process thread queue length | Current length of queue for work items in the processing thread pool. |
| Current process threads active | Current number of threads actively working on queries. |
| Current pyramid operations | Current pyramid operations. |
| Current queries | Current number of queries being actively worked on. |
| Current threads | Current number of threads working on queries. |
| Current worker thread pool | Current count of threads in worker thread pool. These threads answer requests from clients. |
| Current worker threads active | Current count of worker threads active. |
| Data bytes/sec | Count of bytes reads from the data file per second. |
| Data reads/sec | Count of logical I/O reads against the data file per second. |
| Filter rows excluded/sec | Count of filter rows excluded per second. |
| Filter rows included/sec | Count of filter rows included per second. |
| Filtered rows/sec | Count of filtered rows per second. |
| Index bytes/sec | Count of byte reads from the Index file per second. |
| Index reads/sec | Count of logical I/O reads against the index file per second. |
| Map bytes/sec | Count of bytes read from the Map file per second. |
| Map reads/sec | Count of logical input/output (I/O) reads against the Map file per second. |
| Network round trips/sec | Rate of network round trips. This includes all client/server communication. |
| Pyramid operations/sec | Rate of pyramid operations started. |
| Queries answered/sec | Count of queries being answered per second. |
| Queries from cache direct/sec | Count of queries from cache direct per second. |
| Queries from cache filtered/sec | Count of per queries from cache filtered per second. |
| Queries from file/sec | Rate of queries answered from files. |
| Queries requested/sec | Count of query requests arriving at the server per second. |
| Rows read/sec | Count of rows read per second. |
| Rows sent/sec | Count of rows sent per second. |
| Total bytes sent | Accumulating count of bytes sent. |
| Total network round trips | Total network round trips. This includes all client/server communication. |
| Total pyramid operations | Accumulating count of pyramid operations. |
| Total queries answered | Accumulating count of queries answered. |
| Total queries from cache direct | Accumulating count of queries derived directly from cache. Note that this is per partition. |
| Total queries from cache filtered | Accumulating count of queries from cache filtered. |
| Total queries from file | Accumulating count of queries from files. |
| Total queries requested | Accumulating count of queries requested. |
| Total rows sent | Accumulating count of rows sent. |