Home > Uncategorized > SSAS Data Collection: Collecting Perfmon for SSAS

SSAS Data Collection: Collecting Perfmon for SSAS

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.

Advertisements
Categories: Uncategorized
  1. January 12, 2013 at 2:30 am

    Good work! Thanks

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: