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

Can you check on both 32-bit and 64-bit, what is the size of the file
master.vmp in the data folder?

I've seen one or two situations where this file becomes very large and
causes an unexpected slowdown during Commit -- perhaps on x64 something
worsens the problem...

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jéjé" <willgart_A_@xxxxxxxxxxxxxx> wrote in message
news:%23%23QvFWuwGHA.1224@xxxxxxxxxxxxxxxxxxxxxxx
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

  • 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)
  • Re: ADO Connection Timeout
    ... 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)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)