Re: AS2005 ... what is wrong with it?

I've installed AS2005 32 bit version on a 3.8G xeon 4G RAM and restored the
OLAP database.

There changing/saving a role takes 3sec!!!! On the 64 bit maschine 2 mins!!!

What can it be ?

Thanks, Radu



"Radu Colceriu" <radu_colceriu@xxxxxxxxxxx> wrote in message
news:uUjiLPewGHA.4688@xxxxxxxxxxxxxxxxxxxxxxx
My setup:
dual xeon dualcore 2.8 x64 8G RAM, SAN, Win 2003 Standard x64 , SQL2005 EE
x64 + AS 2005 x64, SP 1 + post SP1 hotfix.


I have some OLAP databses (5) installed on the AS server wich are working
good. The problem is that when I change something in one database
(role||deploy) the whole AS2005 is somehow locked!!!
The save process for a role can take up to 2-10 mins in one database and
in the mentime all other databases are locked! no query is working, no
connection with the manangement studio from other users to AS is working.
The processor is 12.5% (1 exec unit: 100%, 7exec units: 1%)

I understand that the database on wich I save the changes *can* get locked
during the process but, why the *others* databases get locked also???!!.

The settings of the server (AS) are the default one.

This is a productive system and when I change a role the whole system
freeze until the saving is finished, even if the role is made in a
TestOLAPDB where I have the only access.

Does anyone have such problems? Do you have AS2005 databases with more
than 150 roles on prod. system?

Does anyone have any ideea?

Thanks,
Radu



.

Relevant Pages

  • AS2005 ... what is wrong with it?
    ... My setup: ... I have some OLAP databses installed on the AS server wich are working ... The problem is that when I change something in one database ...
    (microsoft.public.sqlserver.olap)
  • Re: Deployment of Analysis Services 2000 database
    ... Right Click your OLAP Database and hit 'Copy'. ... Make a backup of your new database and send it to the customer. ... Have them restore the .CAB file on their server. ... Have them re-process the newly restored OLAP database. ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem connecting with ADOMD.NET
    ... AdventureWorksDW is a relational database, the sample OLAP database is ... I can also browse cubes with BI Studio. ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2005 ... what is wrong with it?
    ... the OLAP database. ... I have some OLAP databses installed on the AS server wich are ...
    (microsoft.public.sqlserver.olap)
  • Analysis Services Database & OLAP Service Problems
    ... We had a disk crash on our server a few days ago, ... Analysis Services database files were stored - the disk was replaced ... the OLAP database - I can see the database okay, ...
    (microsoft.public.sqlserver.olap)