14 September 2012

Error in Analysis Services : The system is out of memory (Event ID 2)

If Analysis Services is repeatedly crashing with the following error on a Windows Server 2008 R2 x64 running SQL Server R2 x64 SP1 :
1
Log Name:      Application
2
Source:        MSSQLServerOLAPService
3
Date:          6/09/2012 08:58:13
4
Event ID:      2
5
Task Category: (289)
6
Level:         Information
7
Keywords:      Classic
8
User:          N/A
9
Computer:      rto-dwu.effigy.be
10
Description:
11
The system is out of memory.
12
Event Xml:
13
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
14
  <System>
15
    <Provider Name="MSSQLServerOLAPService" />
16
    <EventID Qualifiers="16673">2</EventID>
17
    <Level>4</Level>
18
    <Task>289</Task>
19
    <Keywords>0x80000000000000</Keywords>
20
    <TimeCreated SystemTime="2012-09-06T06:58:13.000000000Z" />
21
    <EventRecordID>332713</EventRecordID>
22
    <Channel>Application</Channel>
23
    <Computer>rto-dwu.effigy.be</Computer>
24
    <Security />
25
  </System>
26
  <EventData>
27
  </EventData>
28
</Event>
You should simply consider to install the SP2 for SQL Server 2008 R2 ;)

This solves an incomprehensible error seeing that the server has 18GB of RAM installed and the data volume is not so huge.
Post a Comment