Home > Uncategorized > SSAS Crashing Intermittently: Caused by Monitoring / AV Scans

SSAS Crashing Intermittently: Caused by Monitoring / AV Scans

Problem Description:

Analysis Services is crashing intermittently and also producing min-dumps.

Assessment:

This could be one of the issues. For getting full analysis of Mini-Dump you can involve Microsoft Customer Support Services and ask them to analyze dumps.

In this case we found:

The issue is SMS client (CcmExce) does software inventory periodically, and it scans the data folder of Analysis Services. When a job needs to commit, it has to delete older version of data files. At the moment, the SMS client has a file handle on some of the database files, causing SSAS unable to delete the older version of the database, so commit fails and crashes SSAS

As you can see in this Process Monitor – CcmExec is browsing through SQL Folders:

clip_image002

Resolution

We have resolved issue by making an exception in SMS client not to browse / scan SSAS Folders
- Data
- Temp
- Config
- Log

Recommendations

Exclude Analysis Services folders from Virus Scans, File Monitoring Tools, Systems Management Server Client – CcmExec.exe or any other 3p File Monitoring or File Backup Tool.

For SQL engine follow recommendations are given in this link – http://support.microsoft.com/kb/309422

About these ads
Categories: Uncategorized
  1. June 7, 2013 at 5:04 pm

    I feel this is one of the so much vital information for me.
    And i’m satisfied reading your article. But should remark on few basic things, The website style is ideal, the articles is in reality excellent : D. Just right process, cheers

  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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: