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 :
This solves an incomprehensible error seeing that the server has 18GB of RAM installed and the data volume is not so huge.
You should simply consider to install the SP2 for SQL Server 2008 R2 ;)
1 Log Name: Application2 Source: MSSQLServerOLAPService3 Date: 6/09/2012 08:58:134 Event ID: 25 Task Category: (289)6 Level: Information7 Keywords: Classic8 User: N/A9 Computer: rto-dwu.effigy.be10 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>
This solves an incomprehensible error seeing that the server has 18GB of RAM installed and the data volume is not so huge.
Comments