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

does the system takes the same time if the 2 servers have a cold cache?
have you somebody connected or active sessions on the server?

to test, stop the service, start it, apply your new security and verify the
time taken. (stopping the service will insure you that nobody and nothing is
in the cache)



"Radu Colceriu" <radu_colceriu@xxxxxxxxxxx> wrote in message
news:%23pHG$TqwGHA.5044@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)