Measurement tools

This section describes the monitoring and measurement tools that are usually installed with the Windows operating system.

This table shows the tools used for the different monitoring tasks:

Tool Description
Windows Task Manager Add these columns to the Processes tab of Windows Task Manager:
  • Virtual Memory Size: the virtual memory size lists memory consumption more precisely
  • CPU time: the CPU time shows in detail how much time the process consumes
Performance Monitor The Performance Monitor, as part of the Windows installation, is used to monitor measures like the Virtual Memory size more precisely and can record over a long time if required. Additionally, the data it gathers can be collected and analyzed using common Microsoft Excel work sheets.

For convenience, the OLAP Service installs additional counters that can be selected within the Performance Monitor.

SQL Server Profiler The SQL Server Profiler enables you to monitor in detail each single SQL request sent to the server. The requests can be collected and analyzed. For example, the time consumed by the server for specific requests.