Analysis Services
Analysis Server:Last Query Object
The following table lists performance counters from the Microsoft® SQL Server™ 2000 Analysis Services Last Query object. The Last Query object counters provide information about processing on the last query.
| Last Query object counters | Description |
|---|---|
| Answer from cache direct | Number of answers directly from cache. Note that this counter is per partition. |
| Answer from cache filtered | Number of partitions by filtering from other cache entries. |
| Answer from file | Number of partitions contributing to the answer from files. |
| Data avg bytes/read | Average bytes per data file per read operation. |
| Data avg bytes/row | Average bytes per row read during the last query. |
| Data avg rows/read | Average number of rows read per data file read operation during the last query. |
| Data bytes | Bytes read from the data file during the last query. |
| Data bytes total | Data file size in bytes during the last query. Total for all multidimensional OLAP (MOLAP) partitions examined. |
| Data reads | Number of logical I/O reads against the Data file during the last query. |
| DSN requested | Data Set Name requested as the query to the server. (Levels used for each dimension.) |
| DSN used | Data Set Name used to answer the query. (Levels used for each dimension.) |
| Index bytes | Number of bytes read from the Index file during the last query. |
| Index reads | Number of logical I/O reads against the Index file during the last query. |
| Map bytes | Bytes read from the Map file during the last query. |
| Map reads | Number of logical input/output (I/O) reads against the Map file during the last query. |
| Query num | Monotonically increasing query count. Might be useful for tools to check which query this information applies to. |
| Rows created | Number of rows created, which forms the final answer in the aggregation set. Because this is the result of aggregation this counter will usually be much smaller than the Rows read counter. |
| Rows filter excluded | Number of rows that a filter has excluded during the last query. |
| Rows filter included | Number of rows that a filter has included during the last query. |
| Rows filtered | Number of rows against which a filtering operation was applied during the last query. |
| Rows read | Number of rows read from a disk (facts or aggregations) or from the aggregation cache (in memory). |
| Time (ms) | Elapsed time in milliseconds. |
| Total bytes | Bytes read from all files. |
| Total reads | Number of logical I/O reads against all files processed during the last query. |