Re: OLAP running on 32Gb Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What else is on the machine? Just AS?
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Willem Grobbelaar" <WillemGrobbelaar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:05EB0AFE-4E50-49A4-8D63-2737E2B54F35@xxxxxxxxxxxxxxxx
> Is it safe to use the /3Gb switch on this server? If so, would it help?
>
> Thanks
>
> "Dave Wickert [MSFT]" wrote:
>
>> The only comment that I have is that your Memory Conservation threshold
>> is
>> too high.
>> You run the risk of locking up the server since you aren't giving eniough
>> to
>> normal NT operations.You need some memory for stack space, the service
>> executable itself, and some other code not counted in the memory
>> allocation
>> pools.
>>
>> With /3GB, I don't typically recommend setting the high memory above 2700
>> or
>> so; without /3GB I wouldn't set it above 1700 or so. Unfortunately it can
>> take time for the cleaner thread to notice that you memory use exceeds
>> high
>> memory and start triming back the other uses of memory so you need to
>> plan
>> in some leaway. While you might sneek by with 2765, setting it over 2000
>> without /3GB is playing with fire.
>> --
>> Dave Wickert [MSFT]
>> dwickert@xxxxxxxxxxxxxxxxxxxx
>> Program Manager
>> BI Systems Team
>> SQL BI Product Unit (Analysis Services)
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Willem Grobbelaar" <Willem Grobbelaar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
>> in
>> message news:32B39D41-A78C-4673-A5CA-CF14E5AE82C8@xxxxxxxxxxxxxxxx
>> > Configuration:
>> > Windows 2003 Enterprise with SP1
>> > SQL Server 2000 Enterprise Analysis Services with SP3a.
>> > IBM 8-way Server with 32Gb of memory
>> >
>> > I found an article saying that you should not use /3gb switch when
>> > running
>> > 16Gb or more: http://www.sql-server-performance.com/awe_memory.asp
>> > I worked through the AS performance quide
>> > http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx
>> > but could not find anything to help me configure AS on a 16Gb+
>> > configuration
>> > when not using the /3gb switch.
>> >
>> > I did change the following settings in OLAP - default value in bracket:
>> > Memory conservation threshold = 2046 (1023)
>> > Read-ahead buffer size = 64 (4)
>> > Process buffer size = 200 (32)
>> >
>> > We still experience delayed response when browsing cubes from
>> > ProClarity
>> > server, receiving a timeout now and then. This response is irratic.
>> > It
>> > does respond quick, but sometimes, for a few minutes, it slows down and
>> > sometimes with timeout error. Running the same request again later
>> > response
>> > quick, not changing or restarting anything.
>> > On our IBM 4-way, 4Gb memory, /3Gb switch with Memory conservation
>> > threshold
>> > = 2765 it worked great. Other AS settings were set the same as now.
>> > We
>> > replaced the AS server the weekend.
>> >
>> > Any ideas?
>> >
>> > Thanks
>> >
>>
>>
>>


.

Relevant Pages

  • Re: Quick question - dimensions large relative to fact table size
    ... that will improve memory headroom. ... Windows Server 2003 Standard Edition can address a maximum of 2 ... Analysis Services may require more than 2 GB to ... load dimensions into memory, process dimensions, load replica ...
    (microsoft.public.sqlserver.olap)
  • Re: Installation Question
    ... SQL BI Product Unit (Analysis Services) ... be best to have each application installed on a separate server? ... >> Each server application has its own resource allocation technique. ... >> will see the high and low memory allocation which Analysis Services will ...
    (microsoft.public.sqlserver.olap)
  • Re: Installation Question
    ... Each server application has its own resource allocation technique. ... suppose you have 8GB of memory -- ... For Analysis Services, if you use Analysis Manager and right-click on the ...
    (microsoft.public.sqlserver.olap)
  • Out-of-memory while querying possibly causes wrong data to be returned
    ... No matter if I reload the query afterwards, ... After I restart analysis services the value is correct again. ... server so it's not fixed until the server has restarted? ... The server is dedicated to analysis services and has 3GB memory and / ...
    (microsoft.public.sqlserver.olap)
  • Re: MSAS 2gb/3gb limit...
    ... You said that the memory an application ... > address is "working set plus page file usage". ... >> SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.sqlserver.olap)