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

Hi Jeje,

I've tried what you have suggested and there is no difference:

I saved the create role XMLA on both servers then I restarted the AS
services (actually restarted the srv) , connected (taked +2-3sec) with
management studio and then executed the scripts.

the 32 bit: 4 sec
the 64 bit 1:49

the OLAP databses were restored from the same backup file
the OLAP databases access the same SQL2005
both servers are on the same array with diffrernt LUNs
i am the only user in the system

I'm really confused an I presume there is some screwed up installation or
the AS have some issues with dual dual-core xeon x64.

I appreciate your involvement,
Thanks,

Radu



"Jéjé" <willgart_A_@xxxxxxxxxxxxxx> wrote in message
news:%234Xj74RxGHA.2120@xxxxxxxxxxxxxxxxxxxxxxx
the question is not cold cache and warm cache during query time.
the question is:
when you apply your security does the cache is warm or cold?

do this:
save the script which apply the security into an XMLA script
stop both servers 32bits and 64bits
start both servers
run your XMLA script on both server
how many time the XMLA command takes on both servers?


"Radu Colceriu" <radu_colceriu@xxxxxxxxxxx> wrote in message
news:uO0CXLPxGHA.4192@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

@Jeje: no it's not a cold cache thing.... the query times are ok. Only
the management is slow. It is looking like a looking or something.

@Akshai : on the 32 bit the mvp is 1M and on 64 bit is 2.5M. On both
servers I'm the only one accessing it. (not live yet).

What is strange is that on the 64bit in the Data directory I have o lot
of .tmp file like ({uuid}.tmp and {uuid}.sbmp.tmp) and I cannot delete
them even with the AS service stopped.

Any ideeas?
Thanks,
Radu

P.S. I will try in the next days to reinstall the AS ... hope I get no
problems with the uninstall 'cause SQL2005 is working wonderful.





"Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uYdiXjwwGHA.4220@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SAN (NetApp SnapMirror) replicated Exchange databases usability
    ... to stage Exchange 2007 servers at siteB with SG's and databases that are ... This is achieved by having Exchange ...
    (microsoft.public.exchange.design)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... that be the case then I would still work to consolidate the databases ...
    (comp.databases.oracle.server)
  • Re: Why does SQLBrowseInfo call take so long?
    ... I did a similar technique to resolve DNS ... So what I did was start one thread per resolution, ... have 20 servers, this means that it will take 100 seconds to resolve, but if you do them ... if there is some other approach to listing all available databases ...
    (microsoft.public.vc.mfc)