BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

Benchmark YOUR hardware and compare the results V1.1
1 members found this topic helpful
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next
 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
ClintL
Senior Member
Senior Member



Joined: 06 Jan 2011

Posts: 44


flag
PostPosted: Fri Aug 05, 2011 3:10 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Werner, I'm not sure why you say my numbers are 40% less than others. I've had a look at the table of results and the other numbers are 1305s, 252s, 147s, 161s, so mine seems about average I would say.
_________________
SAP CERTIFIED ASSOCIATE (Data Services)
Ixia Consulting
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Fri Aug 05, 2011 3:21 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Yes, but given the power of your servers I would have expected you lead the list. So I am asking myself, is it SQL Server 2005 vs. 2008? VMWare? Shouldn't be the network as the reading is fast.

Anyway, certainly nothing wrong with your numbers as such!

_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Fri Mar 23, 2012 11:25 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Lots of unknowns in the environment and hardware, but here are some results that I recently ran to check a new server:

Source/target db is the same, also the same schema.

Source database type Oracle 11g
Source database hardware Type Unknown
Source database hardware CPU Unknown
Source database hardware Disk Unknown
Target database type Oracle 11g
Target database hardware Type Unknown
Target database hardware CPU Unknown
Target database hardware Disk Unknown
Network from JobServer from/to database 10 GBit Ethernet
DataIntegrator Hardware VM VMWare, unknown with what kind of hardware
Likely all hardware is in the same data center.

Name of the test DS 3.1 Dev
Network from source database to Jobserver 10 GBit Ethernet
DataIntegrator Hardware Type Windows 2003 Standard Edition SP2 32 bit
DataIntegrator Hardware CPU 1 cpu 4 core AMD Opteron 8389 @ 2.91 GHz
DataIntegrator Hardware Memory 3,75 GB

(12.1) 03-21-12 14:51:23 (6636:8152) DATAFLOW: Process to execute data flow <DF_Benchmark_read> is completed.
(12.1) 03-21-12 14:51:23 (5960:6188) PRINTFN: Time______________________________ 221 secounds
(12.1) 03-21-12 15:08:01 (5592:7052) DATAFLOW: Process to execute data flow <DF_Benchmark_API_bulkloader> is completed.
(12.1) 03-21-12 15:08:01 (5960:6188) PRINTFN: Time______________________________ 997 secounds
(12.1) 03-21-12 15:17:57 (4124:1088) DATAFLOW: Process to execute data flow <DF_Benchmark_regular_load> is completed.
(12.1) 03-21-12 15:17:57 (5960:6188) PRINTFN: Time______________________________ 592 secounds
(12.1) 03-21-12 15:18:25 (5856:1572) DATAFLOW: Process to execute data flow <DF_Benchmark_single_thread> is completed.
(12.1) 03-21-12 15:18:25 (5960:6188) PRINTFN: Time______________________________ 13 secounds
(12.1) 03-21-12 15:18:50 (3892:7568) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP1> is completed.
(12.1) 03-21-12 15:18:50 (5960:6188) PRINTFN: Time______________________________ 25 secounds
(12.1) 03-21-12 15:19:17 (2400:1532) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP10> is completed.
(12.1) 03-21-12 15:19:18 (5960:6188) PRINTFN: Time______________________________ 27 secounds


Name of the test DS 3.1 Dev
DataIntegrator Hardware Type Windows Server Enterprise Edition SP2 32 bit
DataIntegrator Hardware CPU 2 cpu 4 core AMD 8389 @ 2.51GHz
DataIntegrator Hardware Memory 9 GB

(12.1) 03-22-12 09:39:04 (5340:6792) DATAFLOW: Process to execute data flow <DF_Benchmark_read> is completed.
(12.1) 03-22-12 09:39:04 (7364:4740) PRINTFN: Time______________________________ 215 secounds
(12.1) 03-22-12 09:52:29 (7536:4932) DATAFLOW: Process to execute data flow <DF_Benchmark_API_bulkloader> is completed.
(12.1) 03-22-12 09:52:29 (7364:4740) PRINTFN: Time______________________________ 805 secounds
(12.1) 03-22-12 10:03:42 (6332:5656) DATAFLOW: Process to execute data flow <DF_Benchmark_regular_load> is completed.
(12.1) 03-22-12 10:03:43 (7364:4740) PRINTFN: Time______________________________ 670 secounds
(12.1) 03-22-12 10:04:23 (4380:5020) DATAFLOW: Process to execute data flow <DF_Benchmark_single_thread> is completed.
(12.1) 03-22-12 10:04:23 (7364:4740) PRINTFN: Time______________________________ 26 secounds
(12.1) 03-22-12 10:04:58 (5172:6948) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP1> is completed.
(12.1) 03-22-12 10:04:59 (7364:4740) PRINTFN: Time______________________________ 35 secounds
(12.1) 03-22-12 10:05:46 (8156:7144) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP10> is completed.
(12.1) 03-22-12 10:05:46 (7364:4740) PRINTFN: Time______________________________ 47 secounds


Name of the test DS 4.0 SP2 Dev
DataIntegrator Hardware Type Windows Server 2008 Enterprise Edition 64 bit
DataIntegrator Hardware CPU 5 cpu 6 core Xeon X7542 @ 2.66GHz
DataIntegrator Hardware Memory 22,5 GB

(14.0) 03-22-12 10:37:08 (5720:7016) DATAFLOW: Process to execute data flow <DF_Benchmark_read> is completed.
(14.0) 03-22-12 10:37:09 (5324:6344) PRINTFN: Time______________________________ 217 secounds
(14.0) 03-22-12 10:48:37 (3768:1624) DATAFLOW: Process to execute data flow <DF_Benchmark_API_bulkloader> is completed.
(14.0) 03-22-12 10:48:37 (5324:6344) PRINTFN: Time______________________________ 688 secounds
(14.0) 03-22-12 10:57:51 (3892:1664) DATAFLOW: Process to execute data flow <DF_Benchmark_regular_load> is completed.
(14.0) 03-22-12 10:57:51 (5324:6344) PRINTFN: Time______________________________ 550 secounds
(14.0) 03-22-12 10:58:16 (5780:6816) DATAFLOW: Process to execute data flow <DF_Benchmark_single_thread> is completed.
(14.0) 03-22-12 10:58:16 (5324:6344) PRINTFN: Time______________________________ 11 secounds
(14.0) 03-22-12 10:58:38 (6204:2588) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP1> is completed.
(14.0) 03-22-12 10:58:38 (5324:6344) PRINTFN: Time______________________________ 21 secounds
(14.0) 03-22-12 10:58:59 (6876:6160) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP10> is completed.
(14.0) 03-22-12 10:58:59 (5324:6344) PRINTFN: Time______________________________ 21 secounds

Interesting to note is that the middle server in the list is better than the first server, but did not perform better. Only difference is the GHz... But I'll re-execute the middle one as that server can be heavily utilized from time to time.


P.s. secounds is a type in the ATL I got from the SAP BODS wiki...
Back to top
bernard timbal
Forum Addict
Forum Addict



Joined: 26 May 2003

Posts: 3634
Location: Paris - FRANCE


flag
PostPosted: Fri Mar 23, 2012 5:23 pm 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Database : MSSQL 2008 R2 SP1
BODI 12.2.0.1
OS : Windows 64 bits
RAM : 16 GB
Core I7-2760 QM CPU @2.40 GHz (4 cores)


Code:
3144   5296   JOB   23/03/2012 22:55:09   Reading job <c7b1bac2_961b_498c_b83b_c1164f8904be> from the repository; Server version is <12.2.0.1>; Repository version is
3144   5296   JOB   23/03/2012 22:55:09   <12.2.0.0000>.
3144   5296   JOB   23/03/2012 22:55:09   Current directory of job <c7b1bac2_961b_498c_b83b_c1164f8904be> is <D:\opt\bodi32\bin>.
3144   5296   JOB   23/03/2012 22:55:09   Starting job on job server host <TYPHOON>, port <3500>.
3144   5296   JOB   23/03/2012 22:55:10   Job <Job_Benchmark> of runid <2012032322550931445296> is initiated by user <boxiadmin>.
3144   5296   JOB   23/03/2012 22:55:10   Processing job <Job_Benchmark>.
3144   5296   JOB   23/03/2012 22:55:10   Optimizing job <Job_Benchmark>.
3144   5296   JOB   23/03/2012 22:55:10   Job <Job_Benchmark> is started.
3920   6080   DATAFLOW   23/03/2012 22:55:10   Process to execute data flow <DF_Benchmark_Setup> is started.
3920   6080   DATAFLOW   23/03/2012 22:55:10   Data flow <DF_Benchmark_Setup> is started.
3920   6080   DATAFLOW   23/03/2012 22:55:10   Data flow <DF_Benchmark_Setup> using IN MEMORY Cache.
3920   6080   DATAFLOW   23/03/2012 22:55:10   Data flow <DF_Benchmark_Setup> is completed successfully.
3920   6080   DATAFLOW   23/03/2012 22:55:10   Process to execute data flow <DF_Benchmark_Setup> is completed.
3144   5296   PRINTFN   23/03/2012 22:55:10   truncating target table via sql() function ...
3144   5296   PRINTFN   23/03/2012 22:55:10   truncating target table via sql() function ...done
6024   5280   DATAFLOW   23/03/2012 22:55:10   Process to execute data flow <DF_Benchmark_read> is started.
6024   5280   DATAFLOW   23/03/2012 22:55:10   Data flow <DF_Benchmark_read> is started.
6024   5280   DATAFLOW   23/03/2012 22:55:10   Data flow <DF_Benchmark_read> using IN MEMORY Cache.
6024   5280   DATAFLOW   23/03/2012 22:55:21   Data flow <DF_Benchmark_read> is completed successfully.
6024   5280   DATAFLOW   23/03/2012 22:55:21   Process to execute data flow <DF_Benchmark_read> is completed.
3144   5296   PRINTFN   23/03/2012 22:55:21   Time______________________________ 10 secounds
1612   6520   DATAFLOW   23/03/2012 22:55:21   Process to execute data flow <DF_Benchmark_API_bulkloader> is started.
1612   6520   DATAFLOW   23/03/2012 22:55:21   Data flow <DF_Benchmark_API_bulkloader> is started.
1612   6520   DATAFLOW   23/03/2012 22:55:21   Data flow <DF_Benchmark_API_bulkloader> using IN MEMORY Cache.
1612   6520   DATAFLOW   23/03/2012 23:06:19   Data flow <DF_Benchmark_API_bulkloader> is completed successfully.
1612   6520   DATAFLOW   23/03/2012 23:06:19   Process to execute data flow <DF_Benchmark_API_bulkloader> is completed.
3144   5296   PRINTFN   23/03/2012 23:06:19   Time______________________________ 658 secounds
3144   5296   PRINTFN   23/03/2012 23:06:19   truncating target table via sql() function ...
3144   5296   PRINTFN   23/03/2012 23:06:19   truncating target table via sql() function ...done
2092   6184   DATAFLOW   23/03/2012 23:06:19   Process to execute data flow <DF_Benchmark_regular_load> is started.
2092   6184   DATAFLOW   23/03/2012 23:06:20   Data flow <DF_Benchmark_regular_load> is started.
2092   6184   DATAFLOW   23/03/2012 23:06:20   Data flow <DF_Benchmark_regular_load> using IN MEMORY Cache.
2092   6184   DATAFLOW   23/03/2012 23:17:17   Data flow <DF_Benchmark_regular_load> is completed successfully.
2092   6184   DATAFLOW   23/03/2012 23:17:17   Process to execute data flow <DF_Benchmark_regular_load> is completed.
3144   5296   PRINTFN   23/03/2012 23:17:18   Time______________________________ 658 secounds
3144   5296   PRINTFN   23/03/2012 23:17:18   truncating target table via sql() function ...
3144   5296   PRINTFN   23/03/2012 23:17:18   truncating target table via sql() function ...done
8120   8048   DATAFLOW   23/03/2012 23:17:18   Process to execute data flow <DF_Benchmark_single_thread> is started.
8120   8048   DATAFLOW   23/03/2012 23:17:18   Data flow <DF_Benchmark_single_thread> is started.
8120   8048   DATAFLOW   23/03/2012 23:17:18   Data flow <DF_Benchmark_single_thread> using IN MEMORY Cache.
8120   8048   DATAFLOW   23/03/2012 23:17:25   Data flow <DF_Benchmark_single_thread> is completed successfully.
8120   8048   DATAFLOW   23/03/2012 23:17:25   Process to execute data flow <DF_Benchmark_single_thread> is completed.
3144   5296   PRINTFN   23/03/2012 23:17:25   Time______________________________ 7 secounds
2436   1672   DATAFLOW   23/03/2012 23:17:25   Process to execute data flow <DF_Benchmark_lookup_DOP1> is started.
2436   1672   DATAFLOW   23/03/2012 23:17:26   Data flow <DF_Benchmark_lookup_DOP1> is started.
2436   1672   DATAFLOW   23/03/2012 23:17:26   Data flow <DF_Benchmark_lookup_DOP1> using IN MEMORY Cache.
2436   1672   DATAFLOW   23/03/2012 23:17:38   Data flow <DF_Benchmark_lookup_DOP1> is completed successfully.
2436   1672   DATAFLOW   23/03/2012 23:17:38   Process to execute data flow <DF_Benchmark_lookup_DOP1> is completed.
3144   5296   PRINTFN   23/03/2012 23:17:38   Time______________________________ 12 secounds
3808   636   DATAFLOW   23/03/2012 23:17:38   Process to execute data flow <DF_Benchmark_lookup_DOP10> is started.
3808   636   DATAFLOW   23/03/2012 23:17:38   Data flow <DF_Benchmark_lookup_DOP10> is started.
3808   636   DATAFLOW   23/03/2012 23:17:38   Data flow <DF_Benchmark_lookup_DOP10> using IN MEMORY Cache.
3808   636   DATAFLOW   23/03/2012 23:17:43   Data flow <DF_Benchmark_lookup_DOP10> is completed successfully.
3808   636   DATAFLOW   23/03/2012 23:17:43   Process to execute data flow <DF_Benchmark_lookup_DOP10> is completed.
3144   5296   PRINTFN   23/03/2012 23:17:43   Time______________________________ 5 secounds
3144   5296   JOB   23/03/2012 23:17:43   Job <Job_Benchmark> is completed successfully.

_________________
Bernard TIMBAL DUCLAUX de MARTIN
BusinessObjects Platform Certified Consultant
Image link
(Co)author of 2 books about SAP BusinessObjects XI3.x and BI4.x Administration
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3456
Location: Massachusetts, USA


flag
PostPosted: Fri Mar 23, 2012 6:54 pm 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

I can't quite match Bernal's CPU numbers, but check out these I/O rates... this is using a FusionIO SSD-on-PCI storage system.

- BODS 14.0.2 (x64) - server 4-core Xeon, 3.2Ghz, Win 2008r2

- SQL server - separate server, SQL 2008r2, 40-core Xeon, array of 4 FusionIO SSD cards

- 10Gb ethernet, on same subnet

- DSCONFIG set to Global DOP of 4

Read - 16
API bulkload - 28
Regular load - 127
Single thread - 6
DOP 1 - 18
DOP 10 - 6


Werner - note the ATL needs adjustment to force the DOP of "single thread" and "DOP 1" dataflows to be a 1, not a 0.

Solid State Disk is the way to go... icon_mrgreen.gif http://www.fusionio.com/
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Sat Mar 24, 2012 7:17 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Arrgh. "Seconds" Copy and paste error. I'll correct both things.
_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Mon Mar 26, 2012 3:32 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Data added, ATL file corrected: the Seconds and the DOP=1 instead of DOP=0. (DOP=0 means "default" as stored in the DSConfig and there is is set to 1 - so usually it will be the same)

@Johannes: While the CPU numbers are fine, reading and loading is not. There is something wrong, either with the test or the computers. Did the monitor log show in the read case that it was reading from multiple partitions in parallel. In other words, there have been many monitor log lines for the reader? Same with the load?
What is most interesting is the fact the API load is slower than a regular SQL insert? Even if the database would enforce logging ("alter table nolog") there should not be that much of a difference. Was the enable-partition loader option set?

@Bernard: Any idea regarding the load times? Why are they the same and why is the number the worst here? Reading is excellent - was there a network inbetween btw??, and CPU is excellent, best numbers we ever had.

@Doug: Finally we can see the 10Gb Ethernet in action. Nice. Writing is just 3 to 5 times faster then the best number we ever got here icon_wink.gif Amazing.

_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Mon Mar 26, 2012 4:51 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Source/target db is the same, also the same schema. Database is different this time as the benchmark was run on the production server.

Source database type Oracle 11g
Source database hardware Type Unknown
Source database hardware CPU Unknown
Source database hardware Disk Unknown
Target database type Oracle 11g
Target database hardware Type Unknown
Target database hardware CPU Unknown
Target database hardware Disk Unknown
Network from JobServer from/to database 10 GBit Ethernet
DataIntegrator Hardware VM VMWare, unknown with what kind of hardware
Likely all hardware is in the same data center.

Name of the test DS 3.1 Prod
Network from source database to Jobserver 10 GBit Ethernet
DataIntegrator Hardware Type Windows 2003 Enterprise Edition SP2 32 bit
DataIntegrator Hardware CPU 1 cpu 4 core AMD Opteron 8389 @ 2.51 GHz
DataIntegrator Hardware Memory 11,7 GB

(12.1) 03-25-12 17:09:36 (4140:4552) DATAFLOW: Process to execute data flow <DF_Benchmark_read> is completed.
(12.1) 03-25-12 17:09:36 (4144:2812) PRINTFN: Time______________________________ 233 secounds
(12.1) 03-25-12 17:22:39 (5880:4908) DATAFLOW: Process to execute data flow <DF_Benchmark_API_bulkloader> is completed.
(12.1) 03-25-12 17:22:39 (4144:2812) PRINTFN: Time______________________________ 783 secounds
(12.1) 03-25-12 17:32:08 (4948:6088) DATAFLOW: Process to execute data flow <DF_Benchmark_regular_load> is completed.
(12.1) 03-25-12 17:32:08 (4144:2812) PRINTFN: Time______________________________ 565 secounds
(12.1) 03-25-12 17:32:36 (3584:3204) DATAFLOW: Process to execute data flow <DF_Benchmark_single_thread> is completed.
(12.1) 03-25-12 17:32:36 (4144:2812) PRINTFN: Time______________________________ 14 secounds
(12.1) 03-25-12 17:33:05 (6084:1896) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP1> is completed.
(12.1) 03-25-12 17:33:05 (4144:2812) PRINTFN: Time______________________________ 28 secounds
(12.1) 03-25-12 17:33:59 (2976:5356) DATAFLOW: Process to execute data flow <DF_Benchmark_lookup_DOP10> is completed.
(12.1) 03-25-12 17:33:59 (4144:2812) PRINTFN: Time______________________________ 53 secounds

Again as Werner said, CPU is fine. Database and i/o is not. Monitor log shows round robin, lots of readers etc.

But I missed this comment:
Quote:
* Please check the API bulkloader settings. enable partition is preferred, if not possible the number of loaders should be set to 8. Only if that's not allowed either use a single bulkloader thread.

API load was on single thread by default from the ATL of the wiki. I'll re-run with partitoning enabled on the target table.
Back to top
bernard timbal
Forum Addict
Forum Addict



Joined: 26 May 2003

Posts: 3634
Location: Paris - FRANCE


flag
PostPosted: Mon Mar 26, 2012 10:29 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Werner Daehn wrote:
@Bernard: Any idea regarding the load times? Why are they the same and why is the number the worst here? Reading is excellent - was there a network inbetween btw??, and CPU is excellent, best numbers we ever had.


POC plateform then BODI and SQL Srv on the same box. No network then icon_wink.gif
Regarding reading and loading time, I think I face a
bottleneck due to the SQL 2008 Server express edition used (only one cpu)

_________________
Bernard TIMBAL DUCLAUX de MARTIN
BusinessObjects Platform Certified Consultant
Image link
(Co)author of 2 books about SAP BusinessObjects XI3.x and BI4.x Administration
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Tue Mar 27, 2012 10:06 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

I have added a Hana run of that benchmark as well. Only tuning is to use a columnar table "create column table TARGET (....".

The machine had low GHz numbers but 128 cores. As all is set to DOP=10 at max, more than 10 cores are never used actually, well maybe 12 cores overall.

Also keep in mind, loading Hana is disk-based as well, not just storing the data in memory. The point in time DS does a commit is the point where the data has to be flushed to disk so in case of a power cut, committed data is not lost.

Comparing the numbers with Doug's recent ones show that. The DS-only cases this machine was slower as it had less CPU power per core. The database was slightly faster. I am not sure if the disk system contains regular disks or SSDs.

_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
aaronwilker
Forum Member
Forum Member



Joined: 14 Sep 2009

Posts: 5
Location: Detroit, MI



PostPosted: Wed Aug 01, 2012 1:55 pm 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Are you still taking benchmarks of hardware? Also, does the server have to only be running the benchmark test and nothing else?
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Thu Aug 02, 2012 10:20 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

This is a service for YOU! You can take any hardware you like and run the benchmark job. I will document it and e.g. make people aware that it was a shared server and if we see something out of the ordinary we try to help.

Usually the hardware used for DS is running the database in addition. Servers with DS exclusively are less common.

_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3456
Location: Massachusetts, USA


flag
PostPosted: Thu Aug 02, 2012 10:29 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

Werner Daehn wrote:
Usually the hardware used for DS is running the database in addition. Servers with DS exclusively are less common.


As an aside, I think this server configuration will change over time, due to the way BODS is licensed and with large-core servers becoming more common.

With the SAP license-core sales model, compared to Microsoft's model, for example... I can get a 24-core server and run SQL Server on it and it's the same license price as a 8-core server. The same is not true for BODS. So in that scenario, if you want to maximize database performance, you'd have to put DS on a separate, small-core server, to stay in license compliance.
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Thu Aug 02, 2012 11:41 am 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

You could assign a subset of the cpus/cores to DS on the large server!
_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3456
Location: Massachusetts, USA


flag
PostPosted: Thu Aug 02, 2012 12:10 pm 
Post subject: Re: Benchmark YOUR hardware and compare the results V1.1

In Windows? How?

And more importantly -- my understanding is - the SAP licensing group wouldn't recognize this as a valid restriction or means to stay in compliance.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 9 of 10 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0545 seconds using 17 queries. (SQL 0.0029 Parse 0.0360 Other 0.0155)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo