Monitoring Cube Performance and Usage - Expert Cube Development with SSAS Multidimensional Models - page 326

Performance Monitor can be found by clicking on the Administrative Tools |
Performance Monitor shortcut, as shown in the following screenshot. There are
differences in the user interface of this tool in different versions of Windows, but
they are not significant for the purposes of this chapter. Performance Monitor can
display performance counter data captured in real time, or it can be used to display
a trace session of performance counter data recorded using the Data Collector Sets
feature of Performance Monitor . Using this trace data is very useful for monitoring a
production server to detect bottlenecks and measure average workload. We suggest
reading the documentation available at http://tinyurl.com/CollectorSet to
understand how to make good use of Data Collector Sets.

The memory counters are divided in two groups. A first set of counters, included
in the Memory category, provides information about the overall consumption of
memory regardless of the consumer (it could be a process, a driver, or the operating
system itself).

• Pages/sec : This is the number of pages read from and written to disk to

resolve hard page faults. An access to a page of virtual memory that has been
paged to disk generates this type of event; the cause is insufficient physical
RAM to satisfy all the memory requests