Re: AS 2000 Processor busy with no query or processing activity
- From: davids@xxxxxxxxxxxxxxxx <davidsthorntonsinccom@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Oct 2006 17:53:01 -0700
From some other things I have read I figured that was go I also found filesin the AS folder called: Partition2006200603200609.18.agg.flex.map which
seems to indicate that this is going on. How do you turn it off?
"Jeje" wrote:
do you have lazy aggregation partitions?.
a lazy aggregation option will evaluate the aggregations of a partition when
the server is IDLE instead of evaluate the aggregation during the processing
time.
this can cause a long and slower processing time, but the cube become
available more quickly to the end user.
but during this background aggregation the server is slower.
regarding the information in the performance counters, this indicates that
you have a lazy aggregation process running.
"davids@xxxxxxxxxxxxxxxx" <davidsthorntonsinccom@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:E06C6E0E-1A66-426E-A483-B040CEFAD36E@xxxxxxxxxxxxxxxx
We are having a problem with our OLAP server. It seems to sit at 25 to
35%
processor busy even with no activity. Using performance monitor this
appears
to occur after partitions are processed in several cubes. Once the
processing has completed it appears to continue to use 25% to 35% of the
processor.
1. Processor Usages Sits at 25 to 35% busy
2. According to Performance Monitor "Analysis Server:Connection" there are
zero "Current Connections" or "http Connections"
3. According to Performance Monitor "Analysis Server: Proc Aggs" 1
Partition
is currently being processed even though no processing is occurring
4. According to Performance Monitor "Analysis Server: Proc Indexes" 1
Partition is currently being processed even though no processing is
occurring
5. According to Performance Monitor "Analysis Server: Proc" 0 Partitions
currently being processed
6. The Process text log shows no processing occurring
7. The server remains in this state for hours on end
8. Taskmgr shows msmdsrv.exe as the only task using the processor
9. When the processor finally returns to 0% busy several hours later the
"Analysis Server: Proc Aggs" and "Analysis Server: Proc Indexes" both
return to zero.
Server Specs:
Windows 2003 Service Pack 1 and all patches installed
MSOLAP 2000 with Service Pack 4
4 Gigs of RAM with /3GB switch
2 Intel Xeon Processors 2.40 Ghz
Maximum Number of threads: 8
Large level defined as: 1000
Minimum Allocated memory: 1024
Memory conservation threshold: 2048
Read ahead buffer: 40
Process buffer size: 2000
Write to log once per 50 queries
- Follow-Ups:
- References:
- Prev by Date: Re: AS 2000 Processor busy with no query or processing activity
- Next by Date: Re: Really simple mdx question
- Previous by thread: Re: AS 2000 Processor busy with no query or processing activity
- Next by thread: Re: AS 2000 Processor busy with no query or processing activity
- Index(es):
Relevant Pages
|
