I need some help with a test, please.

Question

Post reply

I need some help with a test, please.

Viewing 15 posts - 1 through 15 (of 215 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234065 More actions · Answer 1

Hi Jeff

results attached. I have a HP laptop with win XP SP2, 3GB RAM and AMD Turion x2 1.9ghz

query took 23 mins 21 secs

Regards

Perry

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 2

Perry Whittle (9/18/2010)
Hi Jeff
results attached. I have a HP laptop with win XP SP2, 3GB RAM and AMD Turion x2 1.9ghz
query took 23 mins 21 secs
Regards
Perry

Heh... I bought a brand new HP G71 laptop back in February. Dual 64's at 3.3GHZ w/4 GB of ram, Windows 7, 280GB HD, and enough CACHE to choke a mule. I finally powered it up for the first time last night and have started to load stuff on it. Seeing what your machine did compared to the server at work, I can't wait for it to be ready to rock and roll. I also built a nasty wireless network with a 300 yard range so I can take the laptop out to the garage if I need to.

Anyway, thank you for your good time and running the code. I really appreciate it. I hope some other folks jump in soon.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

LutzM SSC Guru Points: 107049 More actions · Answer 3

Hi Jeff,

results attached.

System: WIN XP SP3

Hardware: DELL Vostro, 2QuadCPU @ 2.4GHz, 3.25Gb RAM

Profiler trace available, if needed.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

Jeff ran test on the oldest, least amount of memory, slowest desktop, age - older than dirt. Running Windows XP

Result for SQL 2005 Express in attached word doc.

Will post results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Ron McCullough SSC Guru Points: 63877 More actions · Answer 5

Results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP

Between this and my prior post should give the base line for the worst possible results:

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 6

bitbucket-25253 (9/18/2010)
Results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP
Between this and my prior post should give the base line for the worst possible results:

That run is what I feared the most but just what I was hoping for. The XML-3 run only took about half the time as the While Loop. On all the other machines so far (including mine), it usually takes about the same time or longer. Still, the Tally table smoked everything.

I hope a couple more people jump in. I'll see if I can get ahold of Brad Schultz... he was one of the folks that came up with the absolutely contrary numbers in his testing.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 7

LutzM (9/18/2010)
Hi Jeff,
results attached.
System: WIN XP SP3
Hardware: DELL Vostro, 2QuadCPU @ 2.4GHz, 3.25Gb RAM
Profiler trace available, if needed.

Thanks Lutz! I appreciate it. Nope... no trace needed (at least not yet). Your run was about the same as my server run.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ron McCullough SSC Guru Points: 63877 More actions · Answer 8

Results for SQL 2005 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP

Now do you need one run on SQL 2008 R2? Will be installing that on the bigger / faster box tomorrow (Sunday) and will attempt it after the iinstal.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 9

Jeff, PFA the results my DESKTOP..

Mine runs on

OS : Windows 7 Ultimate,

SQL : SQL Server 2005 Developer Edition RTM (9.0.1399) ,

Processor: Intel(R) Core(TM)2 Duo CPU E7400 @ 2.80GHz, 2800 Mhz, 2 Core(s), 2 Logical Processor(s)

Total RAM : 2 GB

Please tell me if u need further info from my machine.. i will run the code on my office machine which is higher power machine, and publish the results...

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 10

bitbucket-25253 (9/18/2010)
Results for SQL 2005 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP
Now do you need one run on SQL 2008 R2? Will be installing that on the bigger / faster box tomorrow (Sunday) and will attempt it after the iinstal.

That's awesome and I'd love to see a run on SQL 2008 R2. Thanks, Ron!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 11

ColdCoffee (9/18/2010)
Jeff, PFA the results my DESKTOP..
Mine runs on
OS : Windows 7 Ultimate,
SQL : SQL Server 2005 Developer Edition RTM (9.0.1399) ,
Processor: Intel(R) Core(TM)2 Duo CPU E7400 @ 2.80GHz, 2800 Mhz, 2 Core(s), 2 Logical Processor(s)
Total RAM : 2 GB
Please tell me if u need further info from my machine.. i will run the code on my office machine which is higher power machine, and publish the results...

CC... could you do a rerun but in the TEXT mode, please? I'm all setup to read one big text output. Thanks.

And, yeah... I'd love to see the results from the other machine, as well. The more samples I can get, the more plot points I have. Thanks, CC.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 12

Jeff Moden (9/18/2010)
ColdCoffee (9/18/2010)
Jeff, PFA the results my DESKTOP..
Mine runs on
OS : Windows 7 Ultimate,
SQL : SQL Server 2005 Developer Edition RTM (9.0.1399) ,
Processor: Intel(R) Core(TM)2 Duo CPU E7400 @ 2.80GHz, 2800 Mhz, 2 Core(s), 2 Logical Processor(s)
Total RAM : 2 GB
Please tell me if u need further info from my machine.. i will run the code on my office machine which is higher power machine, and publish the results...
CC... could you do a rerun but in the TEXT mode, please? I'm all setup to read one big text output. Thanks.

Anything for u Jeff.. But do i have some 3 hrs ? got to meet my friend now who is in hospital.. so can your consolidation hold for another 3 hrs? Thanks in advance..

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 13

ColdCoffee (9/18/2010)
Jeff Moden (9/18/2010)
ColdCoffee (9/18/2010)
Jeff, PFA the results my DESKTOP..
Mine runs on
OS : Windows 7 Ultimate,
SQL : SQL Server 2005 Developer Edition RTM (9.0.1399) ,
Processor: Intel(R) Core(TM)2 Duo CPU E7400 @ 2.80GHz, 2800 Mhz, 2 Core(s), 2 Logical Processor(s)
Total RAM : 2 GB
Please tell me if u need further info from my machine.. i will run the code on my office machine which is higher power machine, and publish the results...
CC... could you do a rerun but in the TEXT mode, please? I'm all setup to read one big text output. Thanks.
Anything for u Jeff.. But do i have some 3 hrs ? got to meet my friend now who is in hospital.. so can your consolidation hold for another 3 hrs? Thanks in advance..

Anytime is a good time. Absolutely no rush, CC. I'm happy to have this much help, so far. I didn't think I'd have this much help until Monday or so. Thanks for your help and I hope your friend is OK.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 14

It's midnight here. I've got to get some shuteye. Apologies for not answering anything on this post for about the next 8 hours or so (especially to those on the daylight side of the Earth right now).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 15

Jeff Moden (9/18/2010)
ColdCoffee (9/18/2010)
Jeff Moden (9/18/2010)
ColdCoffee (9/18/2010)
Jeff, PFA the results my DESKTOP..
Mine runs on
OS : Windows 7 Ultimate,
SQL : SQL Server 2005 Developer Edition RTM (9.0.1399) ,
Processor: Intel(R) Core(TM)2 Duo CPU E7400 @ 2.80GHz, 2800 Mhz, 2 Core(s), 2 Logical Processor(s)
Total RAM : 2 GB
Please tell me if u need further info from my machine.. i will run the code on my office machine which is higher power machine, and publish the results...
CC... could you do a rerun but in the TEXT mode, please? I'm all setup to read one big text output. Thanks.
Anything for u Jeff.. But do i have some 3 hrs ? got to meet my friend now who is in hospital.. so can your consolidation hold for another 3 hrs? Thanks in advance..
Anytime is a good time. Absolutely no rush, CC. I'm happy to have this much help, so far. I didn't think I'd have this much help until Monday or so. Thanks for your help and I hope your friend is OK.

My friend is doing OK, Jeff.. Thanks for your words 🙂

And i have attached the "Text Mode" Results .. I promise atleast 5 distinct environment's results tomorrow morning once i reach office..Please tel me if i have to provide any further information...