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.

Comments

Popular posts from this blog

Resolve "Cannot download packages whilst offline" issue in Deja-Dup backup software

ubuntu 20.04 / netplan / change mac address and static ip

wireshark ssh remote connect on linux server