Re: Through Put AS vs. SQL Server

#1

30K rows per second = 1800K rows per minute
That is pretty much what AS can process on normal server-class hardware. My
general rule of thumb is 1M rows per minute. You can get better with
higher-end servers and a high-end SAN, but you are going OK.

As a sanity check, I'd go through the AS Performance Guide on optimizing
processing performance.
http://www.microsoft.com/technet/pro.../ansvcspg.mspx

--
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.

"Tiago Rente" <TiagoRente (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I have notice that the current through put from SQL Server to Analysis
Services is aprox from 20000 to 30000 rows per second if both services are
on
the same server.

How can I improve the through put?

I have also notice that using ODBC (Sybase IQ) I am only able to transfer
10000 every 1-2 seconds.

Thanks in advance.

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

Re: Through Put AS vs. SQL Server

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

Re: Through Put AS vs. SQL Server - 08-26-2005 , 12:49 AM