Analysis Server Hangs

Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.Hi enigma,
Do you meant to say by seeing in'Task Manager/ Application'. showing 'Not Responding' ? You try watch using performance counter/AS:Proc:,AS:Agg.Proc objects, after some time, you will get some values related to that. In my case also, I was getting 'this hanging sort of things' but actually it is not.
HTH
====

Originally posted by Enigma
Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.|||Thanks Man,

I was doing exactly the thing you said ... well .. i processed the cube using a DTS yesterday and that worked perfectly fine .

Thanks for all your help

an Error 1058

Having problems connecting to database Enterprise manager
will let me connect but won't let me see any databases
just hangs. Have rebooted P.C. stopped the services etc.
When I Stop Sql server and re-start it says and instance
already running. Need help quickly.
Hi,
Go to Control Panel -- Admin tools - Services -- In the services list see
how many MSSQL Server instances are there in your macine.
I feel that you are trying to look into a diffrent server. To test this
login to Query anayzer and execute the below comamnd:
select name from master..sysdatabases
Thanks
Hari
MCDBA
"John Carlin" <anonymous@.discussions.microsoft.com> wrote in message
news:1e6101c4a2e5$81887230$a301280a@.phx.gbl...
> Having problems connecting to database Enterprise manager
> will let me connect but won't let me see any databases
> just hangs. Have rebooted P.C. stopped the services etc.
> When I Stop Sql server and re-start it says and instance
> already running. Need help quickly.

an Error 1058

Having problems connecting to database Enterprise manager
will let me connect but won't let me see any databases
just hangs. Have rebooted P.C. stopped the services etc.
When I Stop Sql server and re-start it says and instance
already running. Need help quickly.Hi,
Go to Control Panel -- Admin tools - Services -- In the services list see
how many MSSQL Server instances are there in your macine.
I feel that you are trying to look into a diffrent server. To test this
login to Query anayzer and execute the below comamnd:
select name from master..sysdatabases
Thanks
Hari
MCDBA
"John Carlin" <anonymous@.discussions.microsoft.com> wrote in message
news:1e6101c4a2e5$81887230$a301280a@.phx.gbl...
> Having problems connecting to database Enterprise manager
> will let me connect but won't let me see any databases
> just hangs. Have rebooted P.C. stopped the services etc.
> When I Stop Sql server and re-start it says and instance
> already running. Need help quickly.