Hi,

on a 32bit server I receive a System.OutOfMemoryException error when I try
to open my server using the management studio.

Opening a database in visual studio (in dev mode) works fine, but not
through the management studio.

Last week everything works fine.

any idea?

thanks.

Jerome.

In early SP2 we fixed a bug relating to OutOfMemoryException though I
am not sure if it will fix your case. Have you tried to apply the SP2
CTP build
(http://www.microsoft.com/downloads/d...displaylang=en)
and see if it helps?


Jéjé wrote:

its a production server and I can't install CTP versions.

"Chu Xu (MSFT)" <iloveseahawks (AT) gmail (DOT) com> wrote

In early SP2 we fixed a bug relating to OutOfMemoryException though I
am not sure if it will fix your case. Have you tried to apply the SP2
CTP build
(http://www.microsoft.com/downloads/d...displaylang=en)
and see if it helps?


Jéjé wrote:

Today I got also this message first time.
I cannot apply SP2 at this point. Is there any way to go around this
problem?

Vimas


"Jeje" <willgart (AT) hotmail (DOT) com> wrote

my current work around is to open the database in VS2005
(so like a developper and not an administrator)

from here I can do what I need (processing, managing security etc...)
but I have to close and open another database if I want to go from 1
database to another.

other options is to use XML/A commands to do something on the server

"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

my current work around is to open the database in VS2005
(so like a developper and not an administrator)

from here I can do what I need (processing, managing security etc...)
but I have to close and open another database if I want to go from 1
database to another.

other options is to use XML/A commands to do something on the server

"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

Hi Jeje,

Thanks for your reply. I was able to temporary fix this.

Things I try but they did not work:
1. Restarting services
2. Re-deploying last database I was working on.
3. Stopping service, deleting all *.tmp files from data folder, starting
service
4. Restarting machine

What worked:
I had 10 SSAS database on that server, 4 of them about 10GB and more. I
stopped service and then moved out data folders and related DBName.xml file
to another location.I left just 3 databases on the server and this actually
let me start management studio.
This is development 64bit server so I had luxury of doing that.

Regards,


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Hi Jeje,

Thanks for your reply. I was able to temporary fix this.

Things I try but they did not work:
1. Restarting services
2. Re-deploying last database I was working on.
3. Stopping service, deleting all *.tmp files from data folder, starting
service
4. Restarting machine

What worked:
I had 10 SSAS database on that server, 4 of them about 10GB and more. I
stopped service and then moved out data folders and related DBName.xml file
to another location.I left just 3 databases on the server and this actually
let me start management studio.
This is development 64bit server so I had luxury of doing that.

Regards,


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote