 | |
Re: OLAP running on 32Gb Server
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: OLAP running on 32Gb Server -
08-26-2005
, 08:51 AM
|
What else is on the machine? Just AS? -- Dave Wickert [MSFT] dwickert (AT) online (DOT) microsoft.com 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 (AT) discussions (DOT) microsoft.com> wrote in message news:05EB0AFE-4E50-49A4-8D63-2737E2B54F35 (AT) microsoft (DOT) com... 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 (AT) online (DOT) microsoft.com 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 (AT) discussions (DOT) microsoft.com> wrote in message news:32B39D41-A78C-4673-A5CA-CF14E5AE82C8 (AT) microsoft (DOT) com... 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/pro.../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 |
#2
| |||
| |||
|
|
We currently only run AS on this server. We are planning on running ProClarity on the box, but only in a few months. Thanks, Willem "Dave Wickert [MSFT]" wrote: What else is on the machine? Just AS? -- Dave Wickert [MSFT] dwickert (AT) online (DOT) microsoft.com 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 (AT) discussions (DOT) microsoft.com> wrote in message news:05EB0AFE-4E50-49A4-8D63-2737E2B54F35 (AT) microsoft (DOT) com... 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 (AT) online (DOT) microsoft.com 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 (AT) discussions (DOT) microsoft.com wrote in message news:32B39D41-A78C-4673-A5CA-CF14E5AE82C8 (AT) microsoft (DOT) com... 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/pro.../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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.