Monitoring Analysis Services Performance

Analysis Services

Analysis Services

Monitoring Analysis Services Performance

System Monitor is a graphical tool in Microsoft® Windows® 2000 for measuring the performance of your own computer or other computers on a network. (In Microsoft Windows NT® 4.0, this tool is called Performance Monitor). You can use either System Monitor or Performance Monitor to do the tasks described in this section. For each computer, you can view the behavior of objects, such as processors, memory, cache, threads, and processes. Each of these objects has an associated set of counters that measure device usage, queue lengths, delays, and other indicators of throughput and internal congestion. The dynamic link library that provides the performance objects and counters for Microsoft® SQL Server™ 2000 Analysis Services, MSMDCTR80.DLL, is installed into the \Bin subdirectory of the Analysis Services directory.

Windows System Monitor provides charting, alerting, and reporting capabilities that reflect both current activity and ongoing logging. You can open, browse, and chart log files later as if they reflected current activity.

Installing and Uninstalling Analysis Services Performance Counters

To manually install the performance objects and counters supplied by Analysis Services, for use with the System Monitor, the following steps must be performed.

Installing Analysis Services Performance Counters
  1. Add the named values in the following table to the following registry key:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerOLAPService\Performance 
    

    The registry path is described in the following table.

    Named value Value
    Library The file path of the Msmdctr80.dll library
    Open OpenPerformanceData
    Collect CollectPerformanceData
    Close ClosePerformanceData

  2. The information for the performance counters must be installed into the registry. Two files, Msmdctr.ini and Msmdctr.h, are included for this purpose. The two files are typically installed in the same location as the msmdctr80.dll library. To load this information into the registry, use the LODCTR.EXE program distributed with Windows NT 4.0 and Windows 2000. To install, execute the following command in a command prompt:
    LODCTR msmdctr.ini
    
Uninstalling Analysis Services Performance Counters
  1. To uninstall the performance objects and counters, use the UNLODCTR.EXE program distributed with Windows NT 4.0 and Windows 2000 for this purpose. To uninstall, execute the following command in a command prompt:
    UNLODCTR MSSQLServerOLAPService
    

Analysis Services provides objects and counters that can be used to monitor activity in computers running Analysis Services. The topics in the following table of objects provide more detailed information about monitoring Analysis Services performance.

Analysis Services objects Description
Analysis Server:Agg Cache Object Collects statistical information about aggregation cache as related to Analysis Services
Analysis Server:Connection Object Collects statistical information about connections as related to Analysis Services
Analysis Server:Last Query Object Collects statistical information about the last Analysis Services query
Analysis Server:Locks Object Collects statistical information about internal server latches and locks as related to Analysis Services
Analysis Server:Proc Object Collects statistical information about processing data as related to Analysis Services
Analysis Server:Proc Aggs Object Collects statistical information about the processing of aggregations in multidimensional OLAP (MOLAP) data files
Analysis Server:Proc Indexes Object Collects statistical information about the processing of indexes for MOLAP data files
Analysis Server:Query Object Collects statistical information about Analysis Services queries
Analysis Server:Query Dims Object Collects statistical information about Analysis Services query of dimensions and meta data
Analysis Server:Startup Object Collects statistical information about Analysis Services startup

See Also

Analyzing and Optimizing Performance