SSAS Data Collection: Collecting Perfmon for SSAS

  • Article

Applies to Windows7, Windows 2008/R2 and Vista

SQL Server all builds >= SQL 2005

Generally, for troubleshooting SSAS Issues, we recommend to collect below mentioned Perfmon Counters

- All Counters Related to SSAS (MSAS_ or MSOLP$)

For default instance SSAS Counter Name suffix with MSAS.n and for named instance it start with MSOLAP$Instance Name

- System, Process, Processor, Physical Disk, Logical Disk, Memory , Page File

· Got to Run & type Perfmon

· Under Data Collector Set, right click on User Defined and Click New Data Collector Set

clip_image002

· Create New Data Collect Set and Give name as MSTrace & Select Create Manually, Click Next

clip_image004

· Click on Add required counters (Sample Interval as 10 Seconds)

clip_image006

clip_image008

· Here you can specify the Run as user which has Admin Access over box (in case you have logged with credential which is non admin)

clip_image010

  • By default Location of Trace file is - %systemdrive%\PerfLogs\Admin\ but you can change it.

Right Click on Newly Created Trace – Mstrace and select Properties – In Properties under directory tab you can specify the location also you can schedule as per your requirement.

clip_image012

Once you are done with that click OK and Run trace as shown below

 

image

 

Reproduce the issue and collect traces, once you are done just stop traces and check for traces in location which you had provided in Properties.