AS2005 ... what is wrong with it?

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

  • 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)
  • Re: AS2005 ... what is wrong with it?
    ... OLAP database. ... 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: SetUp functions for multiple test cases
    ... couldn't find out how to implement a setup function, ... new database in-memory and fill it with example data for every single ... The True Unit Test Zealots will argue that all tests should be 100% ... SUnit from Smalltalk to Python: SUnit takes full advantage of ...
    (comp.lang.python)
  • [NEWS] Lawson Financials RDBMS Insecurity
    ... Beyond Security would like to welcome Tiscali World Online ... the database itself) to easily compromise the Lawson Financials' database. ... Setup #1 tends to be the preferred configuration method by Lawson ...
    (Securiteam)
  • Re: SetUp functions for multiple test cases
    ... couldn't find out how to implement a setup function, ... new database in-memory and fill it with example data for every single ... The True Unit Test Zealots will argue that all tests should be 100% ... should not interface with external resources like databases. ...
    (comp.lang.python)