Re: Processing Aggregates seems too slow...Any ideas?

#1

Thanks Sean. Raising the process buffer size did help. I did not set
up any distinct counts. Also, thanks for the reference to the perfmon
and white paper.

Dave

"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote

Quote:

A couple of possibilities.

1. You indicated that you raised the process buffer size to 512MB, but the
server is running upwards of 800MB during processing. That might indicate
that you're running into temp files. Temp files will slow down your
processing rate. A couple of ways you can check for this is to either use
the perfmon counters for Analysis Services (there's one for temp file bytes
created) on the proc agg counter. Another sign that you are using temp
files is that processor utilization will tend to be reduced when you are
using temp files.

2. Are you using distinct count? Distinct count requires more memory
during processing than standard measures, all other things being equal.

If you find that you are using temp files, the best thing to do would be to
increase the process buffer size further. That should help reduce your
processing time.

There's a lengthy discussion of this in the following whitepaper.

http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp

I'd recommend that whitepaper for anyone who wants to learn more about "how"
Analysis Services works.

Sean

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"DaveD" <dpdoyle (AT) hotmail (DOT) com> wrote in message

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Processing Aggregates seems too slow...Any ideas?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Processing Aggregates seems too slow...Any ideas? - 01-06-2004 , 10:21 AM