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

Post a Comment

Popular posts from this blog

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

If you got the error message "Cannot download packages whilst offline" but your internet connection is active, this is probably because you've managed the network configuration yourself and the network manager is reporting an offline status even if it's not correct. To fix this issue, simply edit the file /etc/NetworkManager/NetworkManager.conf and change the following configuration to be inline with: [ifupdown] managed=true Then restart the Network Manager : sudo service NetworkManager restart #1
Read more

Connect the Xiaomi Yi Ants Cam to your Synology Surveillance Station

1) Ensure the current firmware of your cam allows you to see the steam without authentication. You can check this using vlc and connecting to rtsp://192.168.1.128:554/ch0_0.h264 If you are able to see the stream, you can go to the next point. Otherwise you have to downgrade the firmware of your cam : Simply place this file on the root of an SD card, insert the SD card in the cam and reset it (a reboot may be sufficient) 2) Create the following file on your synology using putty /volumeX/@appstore/SurveillanceStation/device_pack/camera_support/Xiaomi.conf with this content: [Xiaomi*Ants] api = custom resolution_h264 = 1280x720 default_resolution_h264 = 1280x720 fps_h264_640x480 = 5,10,15,20,25,30 fps_h264_1280x720 = 5,10,15,20,25,30 default_fps_h264_1280x720 = 10 default_image-quality = 5 h264 = rtsp mpeg4 = rtsp mjpeg = rtsp motion = h264,mpeg4,mjpeg motion_param = sensitivity,threshold rtsp_keepalive = none rtsp_protocol = auto,udp,tcp 3) In the surveillanc...
Read more

ubuntu 20.04 / netplan / change mac address and static ip

I wasn't able to set together a virtual mac address and a static IP using netplan: either the mac address didn't change, or IP was not set. I finally got the trick using a fake nic definition that matches the new virtual mac address I've set.    network:   renderer: networkd   ethernets:     ens160:       match:         macaddress: 00:0c:29:5a:69:00       macaddress: 00:50:56:0c:de:a6     ens160_2:       match:         macaddress: 00:50:56:0c:de:a6        addresses: [ 139.99.5.72/32 ]       nameservers:         addresses: [ 8.8.8.8 ]       routes:       - to: 0.0.0.0/0         via: 139.99.5.254      ...
Read more