Through Put AS vs. SQL Server

• Tiago Rente

  Default port

  Points: 1403

  More actions

  August 24, 2005 at 7:20 am

  #111636

  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.

  PS: Originally posted in http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.olap.

• August 29, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  August 29, 2005 at 9:04 am

  #585875

  bigger hardware, separate servers, etc. There are normal items that improve the speed at which things work.

• wildh

  SSCarpal Tunnel

  Points: 4370

  More actions

  August 30, 2005 at 3:36 am

  #586075

  If you have the option (eg no drill through), you could always pre aggregate the data in SQL. This would reduce the load time and aggregation time.