Freigeben über

SSAS Crashing Intermittently: Caused by Monitoring / AV Scans

  • Artikel

Problem Description:

Analysis Services crashed, generating dump file.

Assessment:

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 - https://support.microsoft.com/kb/309422