Analysis Server Memory Upgrade

Dear Anyone,

We recently upgraded our analysis server from a 4GB to 8GB. For a couple of weeks, we noticed that the server memory isnt going up to close to 8GB and only goes to around 4. We use the /3Gb and /PAE on our server.

Can anyone recommend some memory tweaks that we can use on the Analysis Services?

Thanks,

Joseph

Unfortunately in this case having more memory is not going to help.

32 bit version of Analysis Server will not use more than 3Gb of memory.

You should move to 64 bit hardware to be able to take advantage of more memory of your system.
In AS 2005 you should be able to install multiple instances and distribute your databases across instances.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Just want to clarify that this 3GB limitation is on Analysis Services 2005? I thought the memory limitation was for Analysis Services 2005 got a lot bigger from that of the 2000 version. I'm I wrong in thinking this?

Furthermore, can anyone please share the maximum memory configuration we can give Analysis Services 2005 to maximize the available memory? I.e. Analysis 2005 is on a box with 8GB of memory.

|||

Memory limitations for AS2K5 are the same as AS2K -- they are based on the OS (see earlier post).

Therefore to use 8GB of memory you must be running on a 64-bit platform, as a native 64-bit application.

That being said however, what might be confusing you, is that memory usage in AS2K5 has gotten a while lot more efficient. We now have a dimension memory cache, replicas used for dimension security are smaller and more efficient, etc. Thus you can do more with what you have.

But our general advise is still the same -- running on 32-bit hardware, there is no reason to have more than 4GB on your server. See the AS Operations Guide for more guidelines like this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Hope that helps.

_-_-_ Dave

sql

Ammending Data in Field

Hi

New to crystal reports, but familiar with access.

I have been asked to ammend a label that is generated using Crystal 8.5.

Couple of questions:

(1) I cannot see any of the fields for the report, even when I lasso the entire report all I can see is the outline for each box - how can I change this?

(2) For one particular field I have been asked to add a barcode to this. I have the barcode font, and I have copied the exisiting field and changed the font. However, I need to add an '*' to the beginning and end of the exisitng component number - how can I do this?

(3) In the component field, I need to be able to delete any hyphens or spaces in the number (this is for the same field in (2)).

So for example if the component number is:

095-12-6567 7

I need to be able to convert it to:

*0951265677*

Please note that the space or hyphen may not always be present...

Thanks in advance...1 Give more details
2 Create a formula having the code
"*" & {field} & "*" and place it in the details section
(3) Create formula having the code
replace({field},"-","")|||Hi

Thanks for the help - that works like a charm :)

WRT item 1.

In design view everything is invisible, I cannot see text boxs or anything similar. When I lasso everything I see a blue dashed outline showing where it is. I then click at random, somewhere close to the box that I wish to edit/move until I hit the correct one.

When I populate the report with actual data everything (even empty fields) becomes visible|||Did you check this in Preview mode?